Adding same text to all Column A at once

0

Dear Respected Members,

In Column A, employee codes are give series wise. In first cell, I have typed "SMC-" before the employee code.

How to copy/add "SMC-" text in front of all remaining employee codes at once given in Column A?

Kindly guide.

Regards,

Akash Sharma 

Answer
Discuss

Answers

0

Try giving the cells a Custom format

"SMC-"0

or
"SMC-"@

Use the first variation if the employee code is a number, the second one if it's text. Either way, the existing cell content will change and "SMC-" is prefixed to all existing values.

For future entries note that "SMC-" mustn't be entered. If the user does enter the prefix and the format is "SMC-"0 (for numbers) the entry will over-ride the cell format because the entry isn't a number. But if the cell format is "SMC-"@ (for text) the prefix will appear twice.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login