I can't get my concatenate formula results to show

L

Lauren

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
 
C

Chip Pearson

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
 
R

RogerN

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
 
Top