LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mikelee101
 
Posts: n/a
Default Find Fn from right?

Hello,
Is there a way to use the Find function, but have it work right to left
instead of left to right? Here's what I'm trying to do, and any help would
be appreciated:

I have a list of domain names, and I'm trying to extract the TLD from each
one. The problem I'm running into is that some of them are 4th level domains
(i.e. ci.dallas.tx.us) and others have TLDs longer than 3 characters (i.e.
domain.info). Here's what I have, and it seems to work, but if there are any
TLDs out there that I'm not thinking of that are longer than 4 characters,
this will error out on me:

=TRIM(RIGHT(A11,LEN(A11)-FIND(".",A11,LEN(A11)-5)))

If anyone knows of a way to just make the FIND start looking on the right,
that would make it simpler and less prone to future errors....

Thanks to all.

Mike


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I compare data in two worksheets to find matching cells? Gary Excel Discussion (Misc queries) 4 March 2nd 06 09:04 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
Find & Replace results to display specified chosen fields samuel Excel Discussion (Misc queries) 1 December 28th 04 08:43 AM
Another question on how to find duplicate data Eroc Excel Worksheet Functions 2 December 14th 04 05:03 AM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 05:45 PM


All times are GMT +1. The time now is 07:18 PM.

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

About Us

"It's about Microsoft Excel"