Re: how do i do this ?

Tech-Archive recommends: Fix windows errors by optimizing your registry




phil Wrote:
> sorry, i mustn't have explained properly.
> column a and b have different text in. i would like to make the text
> all
> together i one column?
>
>
> Hi Phil
>
> To merge TEXT from A & B
>
> assuming text starts in row 1, you can use this formula to merge the
> text:-
>
> =A1&" "&B1, drag this down the column you put the formula in to merge
> the remaining rows
> __________________
> Hope this helps
>
> Paul


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=400810

.


Quantcast