How do I split a number containing dashes

[DrewPirrit]

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.

 

[al_b_cnu]

Hi,

Try Data|Text to Columns

& specify hyphen as the delimiter.

HTH

Alan

 

[Andrew Poulsom]

Select all your data and choose Data|Text to Columns from the menu. At Step 1 check Delimited and click Next. At Step 2 check Other, type a - and click Finish.

If there is already data to the right of your "numbers" you will need to insert some columns first to avoid it being overwritten.

 

[DrewPirrit]

Thank you, very simple once you know.

Cheers