separate strings

C

cz1

Hey all,

The following is in one cell and I need a way to extract just the numbers so that I can put text to column the numbers. For example, my end goal is to get 39 a1 38 in b2 37 in c1....etc. How can I separate the numbers from the..............and houseplants?

I have over 300 lines of this data!Hope you guys can help thanks!

Houseplants .................... 39 38 37 34 34 38


EggHeadCafe - Software Developer Portal of Choice
ASP.NET Application State and Application Object
http://www.eggheadcafe.com/tutorial...f8-32baafefbb10/aspnet-application-state.aspx
 
T

T. Valko

Try this...

Select the cells in question
Goto Data>Text to Columns
Select Delimited>Next
As delimiters, select Space and Other and enter a dot in the Other box
Click Next
In Step 3 of the wizard you should see down in the Data Preview area the
column with "Houseplants" is highlighted.
In Column Data Format select: Do not import
Click Finish
 
G

Gord Dibben

With your example data.

Data>Text to Columns>Fixed width>Next

Select wizard column 1 & 2 and "Do not import column(skip)"

Finish.


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

Top