I have some alphanumeric data in col A. it has 4 parts.
part 1 starts at char 1 and ends whereever a numeric char is found.
part 2 ends when a alphabetic char is found.
part 3 is only one char always.
part 4 is rest of the string. can be a number or a decimal.
I am looking for a vba code (or excel formula) to split them in the 4 parts in a quick way
thanks in advance
part 1 starts at char 1 and ends whereever a numeric char is found.
part 2 ends when a alphabetic char is found.
part 3 is only one char always.
part 4 is rest of the string. can be a number or a decimal.
I am looking for a vba code (or excel formula) to split them in the 4 parts in a quick way
thanks in advance
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | TREE200717C1550 | TREE | 200717 | C | 1550 | ||
2 | ZAN200626C54 | ZAN | 200626 | C | 54 | ||
3 | ZAN200717C52.5 | ZAN | 200717 | C | 52.5 | ||
4 | BHC200619C19.5 | BHC | 200619 | C | 19.5 | ||
5 | C200619C13.5 | C | 200619 | C | 13.5 | ||
6 | GPS200717C12 | GPS | 200717 | C | 12 | ||
7 | MAXR200821C20 | MAXR | 200821 | C | 20 | ||
8 | |||||||
9 | |||||||
10 | ALPHANUMERIC+NUMERIC+ALPHANUMERIC+NUMERIC OR DECIMAL | ||||||
Sheet1 |