I'm looking for a formula to extract all the text before the last name in a cell

		Microsoft Office Forums > Microsoft Excel > Excel
I'm looking for a formula to extract all the text before the last name in a cell

01-29-2015, 09:07 PM

macropod

Windows 7 64bit I'm looking for a formula to extract all the text before the last name in a cell

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,513

Try:
=LEFT(A1,FIND("‡",SUBSTITUTE(A1," ","‡",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to extract text from a cell and preserve special formatting?	epid011	Word VBA	2	04-04-2014 04:54 PM
Extract Min and highlight cell from source	LeilaniMerle	Excel	3	01-26-2014 11:05 PM
extract text with formula	s7y	Excel	7	06-05-2013 06:18 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Formula that references cell with text in different workbook	no1texan	Excel	3	07-17-2012 05:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:02 AM.