Thursday, May 19, 2005

Mark beat me to the follow up post on splitting out names without formulas by providing the formulas.
He has kindly separated them out so you can see the individual components. As he mentions the FIND Formulas can be integrated into the names formulas.

Tim,
I thought this might be of interest to you and your readers.
Obviously the logic could be extended if you had more than 3 names possible.
You can try to put the formulas for 1st & 2nd space into the formula for each name, but the formulas start to get very scary.
Another tip too with this type of data if there is any possibility of having more than one space between the names, use the TRIM function to eliminate extra spaces.
In the example you gave to overcome the possibility of extra spaces, make sure the 'Treat consecutive deliminators as one' box is checked.
Mark

Names.xls file attached.


Posted by: Jethro | 11:54 PM |