Howdy all,
I have example data below,
DIFF WKND PCT A 1090.52
REG 13621.58
I want the above data split into 2 columns and only ever two columns.
1. All the text or alpha characters in one column
2. All the numeric characters in another column
The result should be below:
DIFF WKND PCT A 1090.52
REG 13621.58
How do I do this? Text to columns by the "delimited space" method winds up that the first row contains 5 columns and the second row contains two, and the numeric portion is slotted in different columns because of it.
Eric Lutz
[Non-text portions of this message have been removed]
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar