| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate strings
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/tutorials...ion-state.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i separate 2 strings of a cell in different cells? | Excel Worksheet Functions | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| Open Excel files in separate sessions, not just separate windows? | Excel Discussion (Misc queries) | |||
| Match data of two identical strings in two separate spreadhseets | Excel Discussion (Misc queries) | |||
| How can I count strings within strings | Excel Worksheet Functions | |||
Threaded Mode
