Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing
Is it possible to parse the data below (including brackets), so that it
appears as set out further down. The first in the list is in cell A2. Solent 36 Group Captain 29 Before You Go 23 Purple Moon 37 Halla San 29 Strategic Mount 324 John Terry 16 Celtic Spirit 32 Misty Dancer 36 Mull Of Dubai 24 Dan Dare 29 High Treason 16 Instructor 84 (59J) Masterofthecourt 11 ............................. Solent Group Captain Before You Go Purple Moon Halla San Strategic Mount John Terry Celtic Spirit Misty Dancer Mull Of Dubai Dan Dare High Treason Instructor Masterofthecourt =IF(ISERR(LEFT(A2,FIND(" ",A2)-1)),A2,LEFT(A2,FIND(" ",A2)-1)) The above will do it, but gets rid of everything except the first word. Is it possible to capitalise the results? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing in Excel? | Excel Worksheet Functions | |||
Instead of Parsing | Excel Discussion (Misc queries) | |||
Parsing Problem | Excel Discussion (Misc queries) | |||
Help With Parsing Data | Excel Discussion (Misc queries) | |||
Parsing Data | Excel Discussion (Misc queries) |