phil Wrote:
if i have 2 columns with different information in them how do i merge
the
two to become one column with all the information in?
i'm trying to use vlookup to search a list of equipment (column B) and
give
me the figure in the box next to it (column C) but some of the info i
need
to find it is in the first column (column A) so i would like to merge
the 2
together . (A+B)

hope this makes sense ?

thanks for your help

Phil

Hi Phil

To merge data from A & B

assuming data starts in row 1, you can use this formula to merge the
data:-

=A1&" "&B1, drag this down the column you put the formula in to merge
the remaining rows


--
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