|
|
#1
10-13-2018, 08:13 PM
|
||||
|
||||
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.
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2007
Linear Mode
