Microsoft Office Forums Formula to separate compound given name from full name

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2018, 08:13 PM
Marcia Marcia is offline Formula to separate compound given name from full name Windows 7 32bit Formula to separate compound given name from full name Office 2007
Competent Performer
Formula to separate compound given name from full name
 
Join Date: May 2018
Location: Philippines
Posts: 192
Marcia is on a distinguished road
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, 8 views)
Reply With Quote
Reply

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
Formula to separate compound given name from full name 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


All times are GMT -7. The time now is 05:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft