Thread: excel formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default excel formula

Post the full input cell that caused the output to fail.
--
Gary''s Student - gsnu200854


"eric" wrote:



"Gary''s Student" wrote:

=MID(A1,FIND("/",A1,1)+1,255) & "." & MID(A1,3,LEN(A1)-FIND("/",A1,1))

--
Gary''s Student - gsnu200854



almost. this resulted to

0R8qzgntg3Rsy4KM1286H. spaces.msn.com/0R8qz