Help to extracting text from text string

		Microsoft Office Forums > Microsoft Excel > Excel
Help to extracting text from text string

02-13-2019, 04:46 AM

xor

Windows 10 Help to extracting text from text string

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

What about

=MID(B3,FIND(":",B3,FIND(":",B3)+1)+2,FIND(":",B3; FIND(":",B3,FIND(":",B3)+1)+2)-1-FIND(":",B3,FIND(":",B3)+1)-1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Formula to extracting text from text string	Haha88	Excel	7	01-13-2019 01:33 AM
Help with Formula to extracting text from text string	Haha88	Excel	9	02-05-2018 01:04 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
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
Extracting a phone number from a string that contains text and numbers.	hommi16	Excel	2	06-05-2013 09:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 PM.