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