word up to last "\"

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

FAQ

Thread Tools

Display Modes

03-14-2012, 07:39 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

Colin Legg will become famous soon enough

Here's one way

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

The formula will return a #VALUE! error if there are no \ characters in the cell being checked.

« Previous Thread | Next Thread »

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 03:54 PM.