Opposite of concatenate

[Chip]

I used the concatenate function to combine columns to make a product be
B18-DST-34-30. Now I want to break that number back apart. All of the
segments are not the same length. Can you reseparate them by using the "-"
as a designator?

 

[Dave Peterson]

If your data is in a single column, you could use:

Select the range
Data|Text to columns
Delimited (by hyphen)

(xl2003 menus)

 

[Chip]

Thank you very much !!!!! It worked.......

If your data is in a single column, you could use:

Select the range
Data|Text to columns
Delimited (by hyphen)

(xl2003 menus)