Remove hyphen and separate / copy numbers

[ExPete]

Hi all..
So my problem is as follows and not sure if it can be done...

In Column B and starting in B2. I have descending data in format of 1-2-3

I need a macro to remove the hyphen, then copy 1 to C2, 2 to D2 and 3 to E2

This needs to be repeated down entire B column and on different sheets the data extends to different lengths but max 26 rows.
Hope thats understandable and Any help would be greatly appreciated..

 

[Fluff]

Hi & welcome to MrExcel.
You can use Text to columns on the Data tab for that.
Select col B > Text to columns > Delimited > Next > Check "Other" & enter - into the box beside it > Finish.

 

[ExPete]

Thank you, I will try it now..