add letter or character to each cell

alvo23

New Member
Joined
Apr 28, 2003
Messages
44
i have a column of 10000 numbers, and i need to add an apostrophe before each number
is there afunction i can do this with? creating a new column is fine, if i can get the apostrophe (') in there.

thanks! i need a function as opposed to code.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

alvo23

New Member
Joined
Apr 28, 2003
Messages
44
hmmm

hey,
i dont think that proper function is working!
thanks though
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,611
Members
412,332
Latest member
hectamuptra
Top