I can't get my concatenate formula results to show
 

When I go to Insert, Funciton, chose concatenate, then the cells I want to
merge, I can see the correct results, but once I hit OK and the wizard closes
I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to
swith between views but no luck

I can't get my concatenate formula results to show
 

It sounds like the cell was formatted to Text before you entered
the formula. Change the format to General and press F2 then
Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lauren" wrote in message
...
When I go to Insert, Funciton, chose concatenate, then the
cells I want to
merge, I can see the correct results, but once I hit OK and the
wizard closes
I can only see the formula =concatenate(A2,B2) - I have tried
the CTRL + ` to
swith between views but no luck

I can't get my concatenate formula results to show
 

ToolsOptionsViewwindow options uncheck the formulas check box

"Lauren" wrote:

When I go to Insert, Funciton, chose concatenate, then the cells I want to
merge, I can see the correct results, but once I hit OK and the wizard closes
I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to
swith between views but no luck

I can't get my concatenate formula results to show
 

Lauren

What you are doing should work but have you tried just using the ampersand
(&) eg =A2&B2. I find this a lot easier and more flexible.

Roger

"Lauren" wrote:

When I go to Insert, Funciton, chose concatenate, then the cells I want to
merge, I can see the correct results, but once I hit OK and the wizard closes
I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to
swith between views but no luck