Thread
:
word up to last "\"
View Single Post
06-08-2012, 08:38 AM
Colin Legg
Windows 7 32bit
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,"\","")))))
Colin Legg
View Public Profile
Find all posts by Colin Legg