Macro to Separate Data

[tpratt]

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

[Kyle123]

Have you tried text to columns?

[tpratt]

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

Thanks for your help!

[Kyle123]

Nope, select the full column, Data > Text To columns > Make sure Delimited is selected > Next > untick tab, in other put the delimiter press finish

You can then just repeat for the other delimiters

[tpratt]

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