Extract Text To left of nth "/"

		Microsoft Office Forums > Microsoft Excel > Excel
Extract Text To left of nth "/"

FAQ

Thread Tools

Display Modes

09-17-2018, 08:39 AM

Pecoflyer

Windows 7 64bit Extract Text To left of nth "/"

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Like this ?
=SUBSTITUTE(A1,LEFT(A1,FIND("%",SUBSTITUTE(A1,"/","%",3))),"")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
extract email from google search "help" please " i can pay no problem after test"	mohamedabdu	Excel Programming	1	08-22-2018 07:43 PM
The "body of text" for all odd-numbered pages are all "vertically-centered-aligned".	keepcalmandreadabook	Word	5	03-27-2017 04:08 PM
"Temporary" files that show up on the left of page	livemusic	Word	4	05-28-2015 04:10 PM
Extract image from pdf file to "word"	026173	Drawing and Graphics	1	11-14-2013 03:13 AM
Why the left edge of an inserted table is out "text boundary" by default?	Jamal NUMAN	Word Tables	2	06-30-2011 04:47 PM

Other Forums: Access Forums

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