Need to append a character to cell data

[Mark]

Hello everyone; I need to append a character to the beginning of a
string in Excel. The problem is, this needs to happen automatically,
so the page acts like a template. Basically, I would like to put an
apostrophe at the beginning of a string in a range of cells, so when a
user copies a list and pastes it into a column, each entry has an
apostrophe added to the beginning. This would make the following
list:

000101
000102
000103

look like this in the cell:

'000101
'000102
'000103


Any information/assistance would be appreciated. If possible, I would
like to accomplish this without macros or manual input from the user
(other than in initial copy/paste). Thank you in advance for your
help!

 

[Zaidy036]

Hello everyone; I need to append a character to the beginning of a
string in Excel. The problem is, this needs to happen automatically,
so the page acts like a template. Basically, I would like to put an
apostrophe at the beginning of a string in a range of cells, so when a
user copies a list and pastes it into a column, each entry has an
apostrophe added to the beginning. This would make the following
list:

000101
000102
000103

look like this in the cell:

'000101
'000102
'000103


Any information/assistance would be appreciated. If possible, I would
like to accomplish this without macros or manual input from the user
(other than in initial copy/paste). Thank you in advance for your
help!

Assumed that the data is being entered as a number formatted using "000000"

- Use the following in the adjacent column to the entries:
=CONCATENATE("'",LEFT("000000",6-LEN(A1)),A1)