Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Find & Replace results to display specified chosen fields | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions | |||
VB Find and Replace | Excel Worksheet Functions |