Can excel merge the text in to different columns?

**Joelb58** · 03-31-2009, 03:33 PM

I paste data into my excel sheet...for example

A B

Red Apple

is there a formula in excel to merge "red" and "apple" so that in column C, it says "Red Apple" in one cell? Thanks.

**oldchippy** · 03-31-2009, 03:34 PM

Hi,

In C1 try this

=A1&" "&B1

**Joelb58** · 03-31-2009, 03:36 PM

works. thank you very much

**asmoghal** · 03-31-2009, 03:40 PM

=concatenate(a1," ",B1)
try this

**Joelb58** · 03-31-2009, 03:41 PM

i wanted to do that so i could do a v lookup with the merged cell....the merge worked but the v lookup wont recognize it. am i doing something wrong or is there a better way to look up the contents of two cells?

**NBVC** · 03-31-2009, 03:43 PM

The first column in the Vlookup table must have the exact same text in it (e.g. Red Apple)

**Joelb58** · 03-31-2009, 03:51 PM

wow it does have to be exact...it was the matter of an extra space...thanks.

**oldchippy** · 03-31-2009, 03:53 PM

May be now?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save