Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Very Urgent - Find / Search Help Needed
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 1,533
Default Very Urgent - Find / Search Help Needed
Hi

Select the cells and goto Data Text to Columns Delemited Next
Delemiters: Check "Other" and enter a dot (.) Next In Data preview the
first column is selected; Column data format: Do not import column. Repeat
for all columns but the last. Change destination if you want to keep
original data. Finish

Hopes this helps
....
Per

"TGV" skrev i meddelelsen
...
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


Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,520
Default 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

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
  
Posts: 63
Default Very Urgent - Find / Search Help Needed
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

Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
  
Posts: 63
Default Very Urgent - Find / Search Help Needed
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

Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,520
Default Very Urgent - Find / Search Help Needed
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

Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
  
Posts: 63
Default Very Urgent - Find / Search Help Needed
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

Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,520
Default Very Urgent - Find / Search Help Needed
If the number of dots are fixed then try Datatext to columns..and
concatenate to get back what you want. If your requirement is for a fomula
then try..the below which is a combination of the earlier two formulas...

=SUBSTITUTE(MID(A1,FIND(".",A1,FIND(".",A1,FIND(". ",A1)+1)+1)+1,LEN(A1))&REPT("~",10),"."&TRIM(RIGHT (SUBSTITUTE(A1,".",REPT("
",LEN(A1))),LEN(A1)))&REPT("~",10),"")


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


"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

Reply With QuoteReply With Quote
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,718
Default Very Urgent - Find / Search Help Needed
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

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help Needed please barkiny Excel Worksheet Functions 3 May 8th 06 04:36 PM
Help Needed Urgent BiggieD Excel Discussion (Misc queries) 7 April 19th 06 05:04 PM
Urgent Help needed Brento Excel Discussion (Misc queries) 0 February 9th 06 09:10 PM
Urgent help needed sp123 Excel Worksheet Functions 1 February 7th 06 01:00 AM
Urgent help needed! skarbanan Excel Worksheet Functions 23 December 30th 05 10:56 PM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement