Hi All,
I have an excel spread sheet that lists all our our customer's business names in column D. I need to do a formula that will create an account number for each customer using the first 5 letters of the business names, excluding special characters, followed by a 4 digit numeric number. EG: A & B Flooring would need to have an account number of ABFLO0001.
I have an excel spread sheet that lists all our our customer's business names in column D. I need to do a formula that will create an account number for each customer using the first 5 letters of the business names, excluding special characters, followed by a 4 digit numeric number. EG: A & B Flooring would need to have an account number of ABFLO0001.