Try this:

=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",99)),297,297))


"TGV" wrote:

THANK U VERY MUCH

FINAL QUESTION "JACOB"

Jacob,

Another one help needed here please tell me how to extract the data from
MIDDLE side FROM 3rd dot to before the last dot (.) i.e gyhjiol.ksdfsl.6546.

The values i require is "gyhjiol.ksdfsl.6546" &
"asdjasdf.dfsjsafl.sdfjslf.sdjsalfasdl"

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

Please suggest me...

Thanks in advance.

TGV
"Jacob Skaria" wrote:

Try
=LEFT(A1,FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1 )-1)

If this post helps click Yes
---------------
Jacob Skaria


"TGV" wrote:

Jacob,

Another one help needed here please tell me how to extract the data from
left side upto 3rd dot (.) i.e abc.2323.zzzzzz.

The values i require is "abc.2323.zzzzzz" & "sdfjas.46465.asdjasdf"

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

Please suggest me...

Thanks in advance.

TGV


"TGV" wrote:

Hi Jacob,

Thaks for your reply and this is what i needed.

TGV

"Jacob Skaria" wrote:

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