still not working

  • Thread starter Thread starter jad
  • Start date Start date
J

jad

what if there is more than one dot
such as
a.j.michael
a.john
a.b.c.john

i need to remove the intial so i got this resutl
michael
john
joh
 
what if there is more than one dot
such as
a.j.michael
a.john
a.b.c.john

i need to remove the intial so i got this resutl
michael
john
john
Click to expand...


=MID(A1,1+FIND("~",SUBSTITUTE(A1,".","~",LEN(A1)
-LEN(SUBSTITUTE(A1,".","")))),255)


--ron
 
Back
Top