Use wildcard in VBA

[krokodilizm]

I have a column of invoice numbers that are not consistent. Some are 4 digits, some are 6 digits (they include the year in front, e.g. 16xxxx). The Find and Replace function is limited. How can I employ VBA to locate all cells that start with 16 and remove the two prefixes?

 

[Peter_SSs]

That was the original idea, to keep the 4 characters on the right hand side.

Not really what you described though.

.. locate all cells that start with 16 and remove the two prefixes?

Remember that we don't know your sheet or data so we only have what you tell and/or show us. As well as a good description, some sample data and expected results are generally a great help in clarifying what you have and want.

 

[My Aswer Is This]

My thought also. Original post said: remove the two prefixes. Well glad he/she received the help they needed.

Not really what you described though.

Remember that we don't know your sheet or data so we only have what you tell and/or show us. As well as a good description, some sample data and expected results are generally a great help in clarifying what you have and want.

 

[krokodilizm]

My thought also. Original post said: remove the two prefixes. Well glad he/she received the help they needed.

He Note it is grammatically wrong to say he/she and then say they. The correct sentence is "Well glad he/she received the help he/she needed". Just saying.
The tendency these days is to use "she" when referring to a hypothetical person. To keep the feminists happy.

 

[tygrrboi]

Pedantic as it may be.. the REAL correct sentence is

"Well, I'm glad that he or she received the help that he or she needed".