Domain character counter

[NicTraders]

Hi,
Does anyone know of a character counter which will automatically strip the dot and the tld from a domain so I can easily get a count on the characters of my domains? Or is there a way to do it in Excel? Thanks!

 

[anantj]

You can do it in excel - Locate the position of the first dot and extract the substring up to that position and then use the len function to get the length

 

[NicTraders]

Hi. When you say locate the dot and extract the substring - do you mean manually, or is there an automatic way to do that?...

 

[usernamex]

For a non-spreadsheet solution, you could run them through either of these checkers and the results include a length column, you can export results too
http://www.bulkseotools.com/bulk-domain-drop-date-checker.php
http://www.bulkseotools.com/bulk-whois-lookup.php

With spreadsheet @anantj is right, LEN function is your best bet

If all your domains are the same extension, my method is just to subtract within the LEN command
Like a list with all .com you can use =LEN($A1)-4

Also be sure there are no trailing or leading spaces, some registrars have to cut paste instead of export and they end up with extra spaces sometimes.

 

[NicTraders]

Ah, brilliant. Thanks both for the assistance, and for the formula @usernamex. I do have a bunch of extensions but I can do them one at a time. Won't take too long. That'll get me sorted. Thx!!

 

[Bravo Mod Team]

The first formula is to extract the domain extension (TLD).

The second formula is to count the domain length without the TLD.

If your headings are named in a table:

=MID([@[Domain Name]],FIND(".",[@[Domain Name]])+1,LEN([@[Domain Name]]))
=LEN(MID([@[Domain Name]],1,FIND(".",[@[Domain Name]])-1))

Otherwise:

=MID(A1,FIND(".",A1)+1,LEN(A1))
=LEN(MID(A1,1,FIND(".",A1)-1))

 

[usernamex]

@Support Team is the winner! This is perfect even for third level domains (like .co.uk etc ) : thumbs up :

=LEN(MID(A1,1,FIND(".",A1)-1))

 

[Asfas1000]

You can use

=FIND(".";A1)-1

to get the length of the domain name in cell A1

 

[NicTraders]

Absolutely brilliant. Thanks @Support Team.
My columns are named but I couldn't get the top formula working for some reason. But the second one worked a charm.

 

[NicTraders]

You can use

=FIND(".";A1)-1

to get the length of the domain name in cell A1

Thanks @Asfas1000 - that one didn't work for me (??) but Support Team has me sorted. Great work all!

 

[usernamex]

For some reason had to type in by hand the one @Asfas1000 provided, then it worked like a charm. That's a pretty nifty hack use of FIND

Thanks for starting this thread @NicTraders - previously would copy paste, add an extra column and parse the domain without extension with "Text to Columns" and it was manual and could get messy if there were third levels involved, this is super way easier!

Using LibreOffice Calc myself, pretty sure there are tiny differences sometimes among the spreadsheet programs

 

[Bravo Mod Team]

My columns are named but I couldn't get the top formula working for some reason.

Highlight the data (columns and rows) » Insert » Table » Add a checkbox to "My table has headers"

Or:

Highlight the data (columns and rows) » Home » Format as table (under "Styles" section) » Choose a design » "My table has headers"

Then it should work if you have a table heading named "Domain Name" (instructions may vary based on version of Excel).

 

[NicTraders]

Highlight the data (columns and rows) » Home » Format as table (under "Styles" section) » Choose a design » "My table has headers"

Ah, indeed. That did it! You're a whizz. Though I'm quite happy with the other way too.