Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2017, 10:50 AM
Haha88 Haha88 is offline Formula to Extract text from a text string Windows 8 Formula to Extract text from a text string Office 2010 32bit
Advanced Beginner
Formula to Extract text from a text string
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default 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
File Type: xlsx Book1.xlsx (9.1 KB, 9 views)
Reply With Quote
  #2  
Old 11-12-2017, 12:54 PM
xor xor is offline Formula to Extract text from a text string Windows 10 Formula to Extract text from a text string Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

=mid(trim(c3),1,find(" ",trim(c3))-1)
Reply With Quote
  #3  
Old 11-14-2017, 01:32 AM
Haha88 Haha88 is offline Formula to Extract text from a text string Windows 8 Formula to Extract text from a text string Office 2010 32bit
Advanced Beginner
Formula to Extract text from a text string
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default

Many thanks. It's a great help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to Extract text from a text string Extract text from a text string Haha88 Excel 8 02-13-2017 05:06 PM
Formula to Extract text from a text string 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
Formula to Extract text from a text string 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 07:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft