View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
 
Posts: 63
Default Very Urgent - Find / Search Help Needed

I am having the below mentioned data in A1 & A2 cells now i want to extract
the last values from the right side which is lying after the dot (.). The
values i require is "jjjjlkk" & "ajaslfasdld".

abc.2323.zzzzzz.gyhjiol.ksdfsl.6546.jjjjlkk
sdfjas.46465.asdjasdf.dfsjsafl.sdfjslf.sdjsalfasdl .ajaslfasdld

Please suggest me how i can do this...

Thanks in advance.

TGV