I'm Having a bit of trouble splitting strings accurately and I thought of just the people that would be able to help.
I have examples of some strings below that I need to split.
27/27/14
2/2/3
214/141/4
217/412/2 ABC
2/4/4 DEF
I Need to be able to split them as following:
27 then 27 then 14
2 then 2 then 3
214 then 141 then 4
217 then 141 then 2 then abc
2 then 4 then 4 then def
("Then" means different cells (hope I made it clear))
Hope someone can help.
Merry xmas
Jay.
Bookmarks