I receive spreadsheets with data in column A which in each single cell looks like:
C FB 3.00 M 1.40 M 1.20 M
I need to be able to extract the 'bits' of data so that each one is in its own cell, for intstance "C", "FB", "3.00", "M" etc. I've found that using the "text to columns" function actually does what I need but I need a formula version (or perhaps a macro) rather than something that has to be used by going through the menus.
Some caveats: so far there are either 7 or 8 "bits", this should stay the same but I can' be sure. Also the number of spaces between the various bits of info is variable, it's not just one space or 10 spaces etc.
I'm not very good at text functions so would appreciate some help!
Cheers
Rob
Bookmarks