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

FAQ

Thread Tools

Display Modes

02-01-2015, 07:14 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

True, but that's not much good when (as in this case) the desired output (which could be multiple given names, initials & honorifics) are all required in a single column.

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

« Previous Thread | Next Thread »

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 06:57 AM.