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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Text?
Surely you can figure it out now that you see how search/find works with
left/mid/right -- Don Guillett Microsoft MVP Excel SalesAid Software "Ken" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Text?
Ok ... I got it ... :)
=RIGHT(E12,LEN(E12)-SEARCH(" ",E12)) Thanks ... Kha "Ken" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Text?
Glad you got it. See how much better if feels to catch the fish yourself. -- Don Guillett Microsoft MVP Excel SalesAid Software "Ken" wrote in message ... Ok ... I got it ... :) =RIGHT(E12,LEN(E12)-SEARCH(" ",E12)) Thanks ... Kha "Ken" wrote: 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 |
Reply |
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 |