I have a Table with Columns : A B C D E F
In Column A I have this Strings like : B1 C2 D7 E4 F9 or C7 F20 ...
How can I Split these String to "correct" Column ?
For example C7 F20 string, I want in Column C to be 7 and in Column F to be 20, the rest empty
Or Aaaa Dzzz, in Column A to be aaa and in Column D to be zzz, the rest empty.
Bookmarks