I need the product code of a list our company's internal listing. All codes start with letters.
Some of the codes look like this:h1_231B01EJD or H1_3431B02eJF.
I want to remove h1_ALLnumbers following. Is there away to do replace all h1*numbers?
Any solution appreciated.
ALSO
Some cells look like this:123ABC123.
To sum up my question, I want to get rid of all numeric prefixes and all "h1_numbers"
123ABC123
h1_231B01EJD
H1_3431B02eJF
EDIT: This would work even better:
Return the first numeric sequence from RIGHT side AND return ALPHA sequence from right side.
Some of the codes look like this:
I want to remove h1_ALLnumbers following. Is there away to do replace all h1*numbers?
Any solution appreciated.
ALSO
Some cells look like this:
To sum up my question, I want to get rid of all numeric prefixes and all "h1_numbers"
EDIT: This would work even better:
Return the first numeric sequence from RIGHT side AND return ALPHA sequence from right side.
Last edited: