separate strings

[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. 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

 

[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