Thread: Formula to separate compound given name from full name
View Single Post
 
Old 10-13-2018, 08:13 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Attached Files
File Type: xlsx Separate Names.xlsx (9.0 KB, 16 views)
Reply With Quote