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

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

If I understood your question correctly, I believe what you need to do is in
column c you need to put =sum(column A + column B)
This will give you the sum in column C

"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

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?


"Christine Lombardo" wrote in
message ...
If I understood your question correctly, I believe what you need to do is
in
column c you need to put =sum(column A + column B)
This will give you the sum in column C

"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

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