ECB
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 62
- Office Version
- 365
- Platform
- MacOS
- Mobile
Hi there,
Regards to all, and I hope you are all staying safe in these mad times.
I have a question about splitting an alphanumeric string that I think I've got clear in my head, I know there will be a simple solution, but I just can't grasp it.
I have an alphanumeric string which consists of one/two letters, following by one/two numbers sometimes followed by a space, followed by a single number followed by two letters.
That is the string could be any of the following:
G2 1AA (which might also be written as G21AA)
G32 1AA (which might also be written as G321AA)
GA2 1AA (which might also be written as GA21AA)
GA32 1AA (which might also be written as GA321AA)
Now I want to split the first part (the single or double letter, and the single or double number) from the second part which is always a single number followed by two letters. I'd like a formula that works for all combinations of the string.
I might have overthought this, as actually all I want to do is take the last 3 letters of the string for the second part, and trim the last 3 letters for the first part - the trim function would strip out spaces.
Am I right?
Regards to all, and I hope you are all staying safe in these mad times.
I have a question about splitting an alphanumeric string that I think I've got clear in my head, I know there will be a simple solution, but I just can't grasp it.
I have an alphanumeric string which consists of one/two letters, following by one/two numbers sometimes followed by a space, followed by a single number followed by two letters.
That is the string could be any of the following:
G2 1AA (which might also be written as G21AA)
G32 1AA (which might also be written as G321AA)
GA2 1AA (which might also be written as GA21AA)
GA32 1AA (which might also be written as GA321AA)
Now I want to split the first part (the single or double letter, and the single or double number) from the second part which is always a single number followed by two letters. I'd like a formula that works for all combinations of the string.
I might have overthought this, as actually all I want to do is take the last 3 letters of the string for the second part, and trim the last 3 letters for the first part - the trim function would strip out spaces.
Am I right?