separate numbers and merge?

[DirectionWorks]

I have a database which has an address column where the address is setup like:
TANSY RD NE-642/MAYO - where the street number (642 is always after the dash, then theres a / which contains the city. I need to get the street number first and eliminate the /city from the column. is there a formula which will work to do this quickly? Its a very large record file.So my outcome would be 642 TANSY RD NE (I actually need it to be 642 NE TANSY RD but I believe the mailer will be able to address correct it from there. Thanks for any help to get this done!

[tom1977]

You can extract number with formula like in attchment

regards

[martindwilson]

all in one go try
=MID(A1,FIND("-",A1)+1,FIND("/",A1)-(FIND("-",A1)+1))&" "&LEFT(A1,FIND("-",A1)-1)