Help with Formula to extracting text from text string

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

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-03-2018, 12:47 PM

jeffreybrown jeffreybrown is offline

Windows Vista Help with Formula to extracting text from text string

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

I might have used a sledge hammer...

D3 copied down to D5

=MID(C3,FIND("::",C3,1)+2,LEN(MID(C3,FIND("::",C3, 1)+2,LEN(C3)))-LEN(MID(C3,FIND("@",SUBSTITUTE(C3,":","@",4)),LEN( C3))))

« Previous Thread | Next Thread »

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
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 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
Extracting a phone number from a string that contains text and numbers.	hommi16	Excel	2	06-05-2013 09:19 PM
Extracting text from a Word Doc into Excel	dgcarlin	Word VBA	1	07-06-2012 05:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:10 PM.