If a data connection brings new data in regularly, I can't be text-to-columnsing each time. It would be good if I could make a formula that split it up automatically each time it refreshed.
Luckily, all of the data is separated by commas, no spaces. So it would have to go from:
12,39,59,Apple,Fruit,12:30,2012-12-05,222222,etc,etc
Doing =LEFT() and a bunch of trims is more work than I'd save doing text to columns.
Is there a simple way to do this with a formula or even a macro?
Bookmarks