still not working

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
 
R

Ron Rosenfeld

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
 
Top