Splitting Data

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

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
 
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.
 
Data>Text to Columns>Delimited by>Other enter a hyphen(dash) and OK


Gord Dibben MS Excel MVP
 

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.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
Splitting Text from single cell in column across multiple Columns 3
Splitting text divided by carriage returns 2
Splitting data into multiple fields. 3
Extracting data 3
Finding a number within a range of numbers 2
Pivot Table from linked spreadsheets 1
Splitting text 11

Back
Top