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