Thread: Macro to Separate Data

I have a column in a spreadsheet, in which several types of data are combined in the following format:

#### - ttttttttttt/llllll, ffff

I need to separate the ####, tttttttttt, llllll, and fffff into different columns, corresponding to the same row as the column from which the data is extracted.

Is there a way to accomplish this with a macro? While the length of the different data varies, the separators (i.e. " - ", "/" and ",") are consistent throughout.

Many thanks for any suggestions.

Tom

I'm sorry, I'm not familiar with that... is it a function or a macro, or a plugin, maybe?

Thanks for your help!

Brilliant! Many thanks! Guess this was something MANY XL users had encountered, so MS just created their own function. Again, MANY thanks!