Hi there,

I'm trying to develop a vba-code that helps me to create an ID NUMBER by extracting the first letter for every customer name in my customers list.

That is: I have my customers list in COLUMN A; and I want to create an ID NUMBER for each customer name in COLUMN B.

I want to create customer ID's out of each customer name.

For instance:

Customer Name Customer ID

J.R. LENNEN CONSTRUCTION, Inc. JRLCInc

Thus, no periods, commas, etc. are to be part of the ID. But when "Inc" or "Co" occur are to be included in ID NUMBER.

ALL SUGGESTIONS ARE WELCOME.