I have a series of 6 digit number that I need to edit to be include (') at
the beginning and end and then place a (,) after each. Is there a quick way
to handle this rather than keying on every line, since there are over 400
lines? EX.
Befo 123456 After should appear: '123456',
I have tried to enter the (') in a cell and then concatenate, however the
(') does not appear in the cell