excel formula
Argh!
I should've known line wrap would fubar the formula!
Here it is in chunks.
Entered all on one line:
=MID(A1,FIND("/",A1)+1,50)&"."&SUBSTITUTE
(MID(A1,FIND(" ",A1)+1,100),MID(A1,FIND
("/",A1),50),"")
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
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
|