word up to last "\"

		Microsoft Office Forums > Microsoft Excel > Excel
word up to last "\"

06-08-2012, 08:38 AM

Colin Legg Colin Legg is offline

$word up to last "\"$ Windows 7 32bit $word up to last "\"$ Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Hi,

Sorry, don't know what happened there....

=RIGHT(A1,LEN(A1)-SEARCH("\ /",SUBSTITUTE(A1,"\","\ /",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
$word up to last "\"$ Issues with Word 2007: making "--" into "—"	kg28	Word	1	02-04-2012 01:33 PM
$word up to last "\"$ Mailing: how to make the "page number" in Word is the same as "row number" in excel w	Jamal NUMAN	Word	1	09-03-2011 11:37 AM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
$word up to last "\"$ How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
$word up to last "\"$ Word 2010: "Screen shot" and "Print Screen" and fitting the page boundaries!	Jamal NUMAN	Word	4	06-30-2011 05:48 PM

Other Forums: Access Forums

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