Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Splitting easier? (Tokeniser?)
I've a column of text, generally in the form
Surname, Forename I want to split into two columns automatically with Forename and Surname separately. I've been able to do it with MID and FIND, but it's quite clunky and wondered if there was a quicker, easier or more elegant way just to tokenise a string based on a defined separator (in this case the character , followed by a space) tks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) |