"Gary''s Student" wrote:

=IF(ISERROR(FIND("/",C30)),C30,your_mid_formula)
--
Gary''s Student - gsnu200773

Thank you Gary that worked perfectly. I was using the same formula but I did
not have the second closing parathesis after the first find. I must be having
a memory lapse.
Thanks again.