Formula to Extract text from a text string

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to Extract text from a text string

11-12-2017, 12:54 PM

xor

Windows 10 Formula to Extract text from a text string

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

=mid(trim(c3),1,find(" ",trim(c3))-1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 PM
I'm looking for a formula to extract all the text before the last name in a cell	Gef	Excel	4	02-01-2015 07:14 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
extract text with formula	s7y	Excel	7	06-05-2013 06:18 AM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 PM.