Answer the question
In order to leave comments, you need to log in
V
V
Vlad2017-02-08 14:52:45
Vlad, 2017-02-08 14:52:45
How to highlight a domain name from an Excel cell?
passagirskieperevozkikbr.ru
dsk.artystyle.com
alinatours.ru
For example, these domains are written in a column in Excel. What is the formula to quickly write down the domain zones of these links
in a separate cell ? .ru .com .ru *dsk.artystyle.com - dot is used twice in this domain..
2 answer(s)
@ClearAirTurbulence
J
John Smith, 2017-02-08 @ClearAirTurbulence
The formulas will look like this:
where
- Finding the position of the last point in the string
- Extracting from the address what is to the right of the found point
Similar questions
N
Z
I
B
_
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question