How do I separate numbers separated by dashes into columns with a formula

[jmkelly1988]

I need to split numbers separated by dashes into different columns.

Some are like 6e5-44352-01
and some are like 90430-08020

The number of dashes can be up to five in a sequence. Any help would be
greatly appreciated.

 

[Momentman]

You can simply use TEXT to columns and use "-" as delimeter

 

[jmkelly1988]

Yes, but is there a formula instead? The reason being I have a specific range that changes daily and would like it to automatically separate every time the values are changed.

 

[FDibbins]

With your data in A1...
B1=TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+1,LEN($A1)))
copied down and across as needed
Adjust the ranges as needed

 

[jmkelly1988]

Does the formula have to be adjacent to the data. If so, is there a way to make it where it doesn't have to be?

 

[FDibbins]

Does the formula have to be adjacent to the data. If so, is there a way to make it where it doesn't have to be?

No it does not have to be. Adjust my suggestion to this...
=TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",LEN($A1))),LEN($A1)*(COLUMNS($A$1:A1)-1)+1,LEN($A1)))