Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting data | Excel Discussion (Misc queries) | |||
Splitting data in cells | Excel Discussion (Misc queries) | |||
splitting data across worksheets | Excel Discussion (Misc queries) | |||
Splitting data in a cell | Excel Discussion (Misc queries) | |||
Splitting Data | Excel Worksheet Functions |