tyronemeister
New Member
- Joined
- Jun 30, 2006
- Messages
- 28
Is there a way to automatically separate numbers and letters in cells when the number of letters and/or numbers varies, preferably with vba? That is, separate them to different columns.
There's no delimiter and the width is not fixed, so the text to columns feature is not useful without sorting the information first. Apparently, isnumber cannot be used to because numbers are recognized as text when concatenated with letters.
Here's an example of what I want to do:
Before separating the data:
12ABB
1ABB
12AB
After separating:
Thanks.
There's no delimiter and the width is not fixed, so the text to columns feature is not useful without sorting the information first. Apparently, isnumber cannot be used to because numbers are recognized as text when concatenated with letters.
Here's an example of what I want to do:
Before separating the data:
12ABB
1ABB
12AB
After separating:
Code:
Col1 Col2
12 ABB
1 ABB
12 AB
Thanks.