Formula to Extract text from a text string

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

FAQ

Thread Tools

Display Modes

Haha88 Formula to Extract text from... 11-12-2017, 10:50 AM

xor =mid(trim(c3),1,find("... 11-12-2017, 12:54 PM

Haha88 Many thanks. It's a great... 11-14-2017, 01:32 AM

11-12-2017, 10:50 AM

Haha88

Formula to Extract text from a text string

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

Formula to Extract text from a text string

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

Attached Files

Book1.xlsx (9.1 KB, 11 views)

« Previous Thread | Next Thread »

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 08:20 PM.