Adding Same Characters In Front Of and Behind a Column of Numbers

b1 =

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

and drag down.

Why not only this.....

="'"&A1&"',"

Might want to be careful here depending on how the results will be handled later on. On Excel 2010, if the

="'"&A1&"',"

result is copy-pasted back in as a value, you would get the desired

'3663',

in the cell. But if you were to click inside the cell text and then hit 'enter', the first apostrophe will become hidden:

3663',

as that initial apostrophe is used by Excel to indicate that the rest of the cell's content is to be handled as text. In Excel 2010, this setting becomes part of the cell's formatting and refuses to later be manually removed (for some moronic reason). Then in order to get the correct content back, you would have to add another apostrophe after the first hidden one.

Hopefully this won't be a concern for jrstites's use. but it is a potential annoyance when handling cell content that has a leading apostrophe.

@sktneer

your solution is even better, although the result is the same.