Thank you to David, Toppers, Naz and Paul, all three varieties did the
trick. I've never played with the FIND function, so I'm going to go
play around with that one.

On Apr 11, 5:16 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=MID(A1,3,FIND("\",MID(A1,3,999))-1)
--
David Biddulph