datatext to columnsdelimitedother -

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Hello,

Is there a way to extract numbers from a cell? Basically I have a list of
APN numbers, sometimes they include letters but they are always broken
with a
dash. I need to extract the three different sections of the APN number
into 3
different cells. For example APN number:

123A-456-789

Needs to be broken up into the following cells as follows:

B1: 123A
C1: 456
D1: 789

As i mentioned earlier numbers and sizes can change, the only constant is
the dash. Thanks for your help.