Link to home
Start Free TrialLog in
Avatar of SAM2009
SAM2009Flag for Canada

asked on

How to convert result in Excel cell to text?

How to convert result in Excel cell to text?


For Exemple:

A1: name
B1: firstname
C1: =A1&"."&B1

I don't want to see the result as formula anymore in C1 but keep the result in C column in text mode (like name.firstname).

How can I do that?
ASKER CERTIFIED SOLUTION
Avatar of shahzadbux
shahzadbux
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Right click on the cell, go to Format Cells, go to Number tab and select Text.

jppinto
Capturar.JPG
Just put ' (apostrophe) before "=" in formula
I dont think you want to paste values... your excel must be shoing you the formulas instead of the results...
1) try formatting it as NOT text, and then F2 and enter
2) make sure excel is set to show the results instead of formulas (see images)
User generated image
User generated image
Avatar of SAM2009

ASKER

Thanks that work fine!