Quote Originally Posted by robert_harper
Hmm no worries I think I'll keep using replace button
If you want a formula try

=MID(A1,FIND("/",A1)+1,999)
Assumes only one / in string as per example

VBA Noob