Click here to Skip to main content
12,458,155 members (56,646 online)
Click here to Skip to main content
Add your own
alternative version

Stats

5.1K views
Posted

Domain Name Generator

, 1 Sep 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
Using Excel to generate random domain names

Introduction

If you know how to build a website, you also know how hard it is to generate a cool domain name. This is also true for signing up a new email address, Facebook account, or for creating a nickname in your MMORPG game.

Background

A good domain name should be easy to read, write, understand and memorize. Short names could be 1 word, 2 words or 3 words long.

Using the Code

First, I pulled a list of 5,000 most common words in English to Excel.

Then I use random number generation and VLookup to create my simple word generator which automatically refreshes itself every time I open or interact with it.

The following Excel functions are in use:

=RANDBETWEEN(1,5000)

=VLOOKUP(C2,$A$1:$B$5001,2,FALSE)

=PROPER('text')

Together:

=PROPER(VLOOKUP(D23,$B$7:$C$5007,2,FALSE))&PROPER(VLOOKUP(E23,$B$7:$C$5007,2,FALSE))

Here's the link to my spreadsheet on OneDrive: http://1drv.ms/1lEtEcv

How it looks:

Points of Interest

By changing the list of initial words to fit your own circustances, you can create a customized generator for your own purposes (medical, engineer, marketing, ...).

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author


You may also be interested in...

Pro
Pro

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160826.1 | Last Updated 2 Sep 2014
Article Copyright 2014 by Thang Believe
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid