Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Text?
Excel2003 ... A Col with TEXT
This formula returns Text to the LEFT of the 1st space found in the text. =LEFT(E2,SEARCH(" ",E2)-1) Now ... What formula will return ALL Text to the RIGHT of the 1st space? Thanks ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting text | Excel Discussion (Misc queries) | |||
Splitting text in a cell | Excel Worksheet Functions | |||
Splitting Text | New Users to Excel | |||
Splitting a delimited text | Excel Discussion (Misc queries) | |||
Splitting Up Text in One Cell To Many | Excel Worksheet Functions |