EmilyCrandall
New Member
- Joined
- May 17, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Emilia*Grace Johnson*IT0037201X*23
Megan*2 Richards*PE018187
Isabel Sneider*TEC017106S*43
Isaiah Lee*TEC017102X
Billy*Bob*3 Joel*TBF016052H*35
Is there a VBA Code using REGEX to delimit the employee ID and age at the end of the line using the "*"?
Some of my rows have up to 4 "*" (used for hyphenated names and/or the amount of positions worked) but I only want the employee ID and age to be delimited. Some rows don't have an age either.
(If it helps, the ages will always only be 2 digits)
Any ideas would help greatly.
Megan*2 Richards*PE018187
Isabel Sneider*TEC017106S*43
Isaiah Lee*TEC017102X
Billy*Bob*3 Joel*TBF016052H*35
Is there a VBA Code using REGEX to delimit the employee ID and age at the end of the line using the "*"?
Some of my rows have up to 4 "*" (used for hyphenated names and/or the amount of positions worked) but I only want the employee ID and age to be delimited. Some rows don't have an age either.
(If it helps, the ages will always only be 2 digits)
Any ideas would help greatly.