Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 10-13-2018, 08:13 PM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
Join Date: May 2018
Posts: 154
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

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

All times are GMT -7. The time now is 04:53 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft