You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"eric" wrote in message
...
it worked! thanks!

"T. Valko" wrote:

That formula fails on the 2nd example.

It might be better to find the 1st space rather than assume the start of
the
string is always 1<space.

=MID(A1,FIND("/",A1)+1,50)&"."&SUBSTITUTE(MID(A1,FIND("
",A1)+1,100),MID(A1,FIND("/",A1),50),"")

--
Biff
Microsoft Excel MVP


"Gary''s Student" wrote in
message
...
=MID(A1,FIND("/",A1,1)+1,255) & "." & MID(A1,3,LEN(A1)-FIND("/",A1,1))

--
Gary''s Student - gsnu200854