apostrophe

how can i insert an apostrophe in front of numbers in a column so that they are now recognized as text. I have an entire column and can't seem to use concat or other functions to accomplish this.

excel

Riny_van_Eekelen
Dec 17, 2021
TonyA730 Alternatively, just use "Text to Columns" (TTC) on the Data ribbon. Select the range of numbers (column wise) you want to convert to text. Press the TTC button. "Next", "Next" (i.e. change nothing in steps 1 and 2. Then in step 3 of 3, select Text as the data type. Press Finish.
The numbers will now be texts (left aligned), no apostrophes needed and no need to format the cells as text either.

Riny_van_Eekelen

Platinum Contributor

Dec 17, 2021

TonyA730 Alternatively, just use "Text to Columns" (TTC) on the Data ribbon. Select the range of numbers (column wise) you want to convert to text. Press the TTC button. "Next", "Next" (i.e. change nothing in steps 1 and 2. Then in step 3 of 3, select Text as the data type. Press Finish.

The numbers will now be texts (left aligned), no apostrophes needed and no need to format the cells as text either.

TonyA730

Copper Contributor

Dec 17, 2021

Oh my - thank you - this was sending me over the edge wasting time... I tried every formula I could dream of. LOL
Thanks again!

Forum Discussion

apostrophe

Resources