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...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=400810