Splitting Data
 

I have multiple cells within a column that contain text and numbers. I need
to split out the numbers. I don't think Data Text to Columns will work
because the numbers do not line up. Below is an example. Can anyone save me
from having to manually enter these numbers??

Virtualizer for Capacity on Demand - 38756
Virtualizer for High Availability - 38758
Marimba OS Management - 38759
BootManage Administrator by Bootix - 38663

Splitting Data
 

If the dash in front of your numbers will be the only dash in the text, you
can use still use Data/Text To Columns. Choose delimited, uncheck any
checked delimiters and put a dash in the field next to the checkbox labeled
"Other", then click Finish.

--
Rick (MVP - Excel)


"Nicole" wrote in message
...
I have multiple cells within a column that contain text and numbers. I
need
to split out the numbers. I don't think Data Text to Columns will work
because the numbers do not line up. Below is an example. Can anyone save
me
from having to manually enter these numbers??

Virtualizer for Capacity on Demand - 38756
Virtualizer for High Availability - 38758
Marimba OS Management - 38759
BootManage Administrator by Bootix - 38663

Splitting Data
 

DataText to ColumnsDelimited byOther enter a hyphen(dash) and OK


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 13:11:01 -0800, Nicole
wrote:

I have multiple cells within a column that contain text and numbers. I need
to split out the numbers. I don't think Data Text to Columns will work
because the numbers do not line up. Below is an example. Can anyone save me
from having to manually enter these numbers??

Virtualizer for Capacity on Demand - 38756
Virtualizer for High Availability - 38758
Marimba OS Management - 38759
BootManage Administrator by Bootix - 38663