Hello Friends,
I need help with splitting an alphanumerical string. I am using Excel to manage this data but if you have any better suggestion, please let me know.
I have a string starting with numerical part which has at the end some soft of alphabetical character followed by 1-9 numerical number. I want to split string when it encounters alphabetic character.
I HAVE:
Column 1
4550368
458424377A0
5084532B4
I WANT:
Column 1 Column 2
4550368
458424377 A0
5084532 B4
As you have observed here, I have varied length for the string.
Please advice. Thanks in advance.
I need help with splitting an alphanumerical string. I am using Excel to manage this data but if you have any better suggestion, please let me know.
I have a string starting with numerical part which has at the end some soft of alphabetical character followed by 1-9 numerical number. I want to split string when it encounters alphabetic character.
I HAVE:
Column 1
4550368
458424377A0
5084532B4
I WANT:
Column 1 Column 2
4550368
458424377 A0
5084532 B4
As you have observed here, I have varied length for the string.
Please advice. Thanks in advance.