200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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
Try giving the cells a Custom format
"SMC-"0"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.