I need to renumber +- 1500 accounts with our new Account Numbering Convention. The plan is to use the following numbering convention.
Account Name :Standard Wholesale
Account Number Should be :STAN001
Account Name :Standard Trading
Account Number Should be :STAN002
Account Name :Great Projects
Account Number Should be :GREA001
So basically use the first 4 characters of the name followed by a sequence number. Is it possible to accomplish this on excel?