| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to split number and text string to separate cells?
I have in cells A1:A1000....a combination of number and text, ex.."123 abc abc"
I wanted to split into 2 separate cells...I've done the number part...using "=LEFT(A1,FIND(" ",A1))" to cell B1 but I can't seem to figure out how to split out "abc abc" to C1? Any help is appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split a number from one cell to separate cells for each | Excel Discussion (Misc queries) | |||
| separate a text cell to many number cells | Excel Worksheet Functions | |||
| Parsing a text string into separate cells | Excel Worksheet Functions | |||
| split text into separate cells | Excel Worksheet Functions | |||
| Split date in cell into 2 separate cells | Excel Discussion (Misc queries) | |||
Threaded Mode
