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

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" <Lauren@discussions.microsoft.com> wrote in message
news:B20C63E8-15CE-47B2-99B7-04E5BE0EDD7D@microsoft.com...
> 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

Tools>Options>View>window 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

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