Very Urgent - Find / Search Help Needed
With your data in cell A1 try the below formula
=TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",LEN(A1))),LEN(A1)))
If this post helps click Yes
---------------
Jacob Skaria
"TGV" wrote:
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
|