how do i do this ?

P

phil

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
 
P

Paul Sheppard

phil said:
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
Click to expand...

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
 
C

Christine Lombardo

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
 
P

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

Paul Sheppard

phil said:
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
Click to expand...
 
Top