How to generate an email address from firstname and lastname

Let's say that you work at one of those companies that has a nice leftover-from-the-8-character-file-name-limit-days email format. Solveig Haugland becomes shauglan, Bob Nelson becomes bnelson, and so on.

And let's also say, as long as we're dreaming up situations, that you've got a spreadsheet full of first and last names but you don't have their emails.

You could type in all the email addresses but even an intern who's paid well by the hour is going to balk at that.

The faster way is to use CONCATENATE and LEFT.

You've got this.

Firstname	Lastname	Email
Shelly	Nelson
Bill	Mizrahi
Steve	Santos

You want this.

Firstname	Lastname	Email
Shelly	Nelson	snelson@company.com
Bill	Mizrahi	bmizrahi@company.com
Steve	Santos	ssantos@company.com

Here's how to get it.

Syntax

=CONCATENATE(LEFT(cell_with_firstname;1);LEFT(cell_with_lastname;7);"@yourdomain")

Example

Comments

[WOW GOLD]

Nice job! Thanks for your information.

-----------------
http://www.vcsale.com/

[wow gold]

buy wow gold , mmoinn is your best choice is very simple to order, we give you the cheapest wow gold and wow power leveling , you can buy a peaceful Mentality, we are confident that our services.

[wowgolds987]

As soon as possible to buy wow gold from mmoinn.com Lane! Let you enjoy the fun of the game to you! We provide you with cheap wow gold and wow power leveling , you will get a guarantee of confidence!

[gold56465]

Take a look at our price of wow gold. You will find it is a loyal and reliable store of cheap wow goldfor sale online. You may compare the price then buy wow

gold from us . It will be a great fun that you will save huge money. We know what a gamer need so that we will provide you a really instant way of delivery,

if you buy world of warcraft gold, gold wow from us. Just place your order to buy wow gold from us then feel the world class service.
http://veryge.com/

[lynn]

thanks.
http://www.ihappyshopping.com/
http://www.laptopspartstore.com/
nice of you.

[rose]

http://www.sunvalleyus.com
http://www.papatek.com

[Penis Enlargement Vigrx]

We are one of the largest sellers of Natural Herbal products which contains a wide variety of Herbal products such as Penis Enlargement products, Weight Loss Products, General Health Products. Please visit us and get yourself one of the best Herbal products which does not have any kind of side effects and which will solve your problems.
http://www.penisenlargement-vigrx.com

[Cheap Computers]

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place, i will must refer this information with reference on my website i.e www.electrocomputerwarehouse.com

[Cheap Computers]

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place, i will must refer this information with reference on my website i.e www.electrocomputerwarehouse.com

[Cheap computer]

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place, i will must refer this information with reference on my website i.e www.electrocomputerwarehouse.com

[r4ds r4i]

http://www.digimartz.com
http://www.digimartz.com/Wholesale-itouch2-itouchds_c49
http://www.digimartz.com/itouch-ds-card-for-nds-ndsl_p255.html
http://www.digimartz.com/itouchds-card-with-microsd-tf-1gb-combo_p256.html
http://www.digimartz.com/itouchds-card-with-microsd-tf-2gb-combo_p257.html
http://www.digimartz.com/itouchds-card-with-microsd-tf-4gb-combo_p258.html
http://www.digimartz.com/itouch2-dsi-compatible-for-ndsndsldsi_p291.html
http://www.digimartz.com/supercard-ds-one_p199.html
http://www.digimartz.com/r4i-revolution-for-ils_p297.html
http://www.digimartz.com/microsoft-xbox-360-wireless-controller_p225.html
http://www.digimartz.com/512mb-xbox-360-memory-card-unit_p186.html
http://www.digimartz.com/Wholesale-dstt-dstti_c42
http://www.digimartz.com/Wholesale-itouch2-itouchds_c49
http://www.digimartz.com/n5-revolution-for-ds-and-nds-lite-n5ds_p276.html

[r4 ds]

Thanks for the syntax.I’ll try it out as soon as I’ve gotten the stuff needed.

[cheap computers]

Thanks for sharing your views that really helps the new visitors of this blog.

[Penis Enlargement]

Increase your penis size up to 3 inches with our amazing penis enlargement device. The SizeGenetics device is medically endorsed and can help you aquire a larger and stronger penis.

[www.ebizoptimize.com/social-bookmark-submission.html]

We make sure that you completely understand the impact and the effectiveness of our social bookmarking submission service, by offering you a free submission

[online store]

The Best Online Store, buy a Computer, Camera Photos, Watches, Wireless Accessories, Netbook, Cell Phones, Electronics, Books, Printers, Scanners, LCD Monitors, Wireless Accessories

[online store]

The Best Online Store, buy a Computer, Camera Photos, Watches, Wireless Accessories, Netbook, Cell Phones, Electronics, Books, Printers, Scanners, LCD Monitors, Wireless Accessories

[Penis Enlargement]

Sexual health is an important part of overall health and male enhancement for sex becomes essential when faced with sexual disorders; even if you keep sex aside,