Format cells with inserted text

C

CCJ

I want to add an apostrophe before the number I will be
putting into a cell; then add an apostrophe and comma
after the number. EX: '12345',
I have all the numbers already in the fields and want to
change them so the format is as above. Any ideas.
Thanks
 
T

theillknight

Try using the concatenate() or & function.

If the cell you want to format is A1, then you can write a formul
like:

=concatenate("'",A1,"'",",")

or

="'"&A1&"'"&","

It's confusing because of the font, but the first part is really
single quotation mark surrounded by double quotation marks: " ' "

A1 doesn't need quotes, as that is the referenced cell. Then ' is i
quotes. Then , is in Quotes
 
Top