#1
|
||||
|
||||
Formula to separate compound given name from full name
I spent several hours searching for the formula to separate a compound given name from a list of full names but nothing came out. Here's a list of the full names that I want to separate through a formula, not text to columns method. I need formulas in columns b and c that recognize compound names like "Mary Ann". Sample attached. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I separate an address into separate cells | Austcart | Excel | 2 | 01-18-2015 03:48 PM |
Compound Countifs Query not working | Lonercom | Excel | 5 | 06-28-2013 10:27 AM |
Compound animations | 73MustangBill | PowerPoint | 0 | 06-05-2013 01:38 PM |
Can I use the filter function to separate letters into separate files? | drhauser | Mail Merge | 2 | 12-14-2011 02:18 PM |
Any easy way to separate a Word document into separate files? | SamHelm | Word | 0 | 08-21-2010 05:29 AM |