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?
LVL 1
SAM2009Asked:
Who is Participating?
 
shahzadbuxConnect With a Mentor Commented:
Copy\Paste Values!

Do you need to retain the formulas?

If you don't then highlight the cells in C and Copy, the select paste special (right click) and select values.

If you need to keep the formulas then you'll need to do the paste values in another column.
0
 
jppintoCommented:
Right click on the cell, go to Format Cells, go to Number tab and select Text.

jppinto
Capturar.JPG
0
 
skrgaCommented:
Just put ' (apostrophe) before "=" in formula
0
 
FernandoFernandesCommented:
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)
imagem 01
imagem 02
0
 
SAM2009Author Commented:
Thanks that work fine!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.