Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add (') at the beginning and end of a series of numbers?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add (') at the beginning and end of a series of numbers?
use the following helper formula.
=CONCATENATE("'",A1,"',") to clarify, left parentheses, then a double quote, then a single quote, then a double quote, then a comma, then A1, then a double quote, then a single quote, then a comma and lastly a double quote followed by a right parentheses. "Ann" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|