#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=mid(trim(c3),1,find(" ",trim(c3))-1)
|
#3
|
|||
|
|||
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 |