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