1) Select your data
2) Data > Text to Columns
3) Choose Delimited as your Data Type
4) Click Next
5) Check Other as your delimiter and type the hyphen into the box next
to it
6) Click OK/Finish
Thanx I had to do some juggling around, but it worked
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.