I am importing a xml file. The resulting file has one range of cells which contain multiple numbers.
numbers are in the format xx-xx-xx-xx for example 12-1-2-4.
I need to break the bunbers up to individual cells.
so if A1 = 12-1-2-4
it becomes
B1 = 12
C1 = 1
D1 = 2
E1 = 4
Is this doable?
Bookmarks