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