View Single Post
  #4   Report Post  
phil
 
Posts: n/a
Default

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