Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2014, 12:31 AM
projectpupil7 projectpupil7 is offline Text in string Windows 7 64bit Text in string Office 2010 64bit
Novice
Text in string
 
Join Date: Nov 2014
Posts: 5
projectpupil7 is on a distinguished road
Default


Hi Pecoflyer, thanks for the reply. Your answer was as expected and i did try this method but didn't get my answer i will have to try again. However, in my search i was offerred this rather long formula solution which works a treat so i would like to share this with the community.

=MID(SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1),FIND("/",SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1))+1,FIND("/",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1),"/","",1))-FIND("/",SUBSTITUTE(SUBSTITUTE(E1,"/","",1),"/","",1)))

Thanks for the help.

Oh!! where is the thanks button
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in 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
Text in string Extracting a phone number from a string that contains text and numbers. hommi16 Excel 2 06-05-2013 09:19 PM
Text in string Find and replace a string of text errtu Word 1 01-31-2013 02:09 PM
Text in string Convert numbers to a specific text string francis Excel 1 10-06-2011 01:43 PM
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 10:15 AM.


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