Microsoft Office Forums - View Single Post - word up to last "\"

Thread: word up to last "\"

View Single Post

Old

03-14-2012, 07:39 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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.

Reply With Quote