Formula to Extract text from a text string

Haha88 · #1 11-12-2017, 10:50 AM

Hi,

Can someone please help with a formula to extract text from a text string with un-predicted empty spaces in front of the beginning text.

I attached an example of what I'd like to extract.

Thank you.

Haha88

xor · #2 11-12-2017, 12:54 PM

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

Haha88 · #3 11-14-2017, 01:32 AM

Many thanks. It's a great help.

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