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	[email protected]
Bill	Mizrahi	[email protected]
Steve	Santos	[email protected]

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,

[Dell GX270]

The Best Online Store, buy a Computer, Camera Photos, Watches, Wireless Accessories, Netbook, Cell Phones, Electronics, Books, Printers, Scanners, LCD Monitors, Wireless Accessories http://www.myonline-store.com

[cheap computers]

Reseller of Grade 'A' Cheap Used/Refurbished Computers, Used Refurbished Computers, Cheap Refurbished Computers at Discounted Prices. Dealers in Cheap Used HP and Dell Computer Systems. Visit our website at http://www.pctechoutlet.com for weekly special deals.

[used computers]

Reseller of Grade 'A' Cheap Used/Refurbished Computers, Used Refurbished Computers, Cheap Refurbished Computers at Discounted Prices. Dealers in Cheap Used HP and Dell Computer Systems. Visit our website at http://www.pctechoutlet.com for weekly special deals.

[geshichaunshuo]

体检车
家具五金
过滤器
混合器
标准柜体
烤漆门板
输送机
滤油器
滤油车
玻璃钢格栅
拉挤型材
织带机
平面磨床
静态混合器
煤气静态混合器
自清洗过滤器
电脑绗缝机
开松机
大棚
脚手架
竹节纱装置
永磁电机
铝青铜
苏通大桥
镊子
高压油泵
柱塞泵
路桥工程
塑料排水板
透明母料
塑料消泡剂
热熔胶粒
玻璃钢格栅
玻璃钢盖板
Best flv converter
Convert FLV to DVD
FLV Converter for Mac
FLV to Video Converter
DVD Ripper for Mac
how to convert
Ultrasonic Flaw Detector
Technology about Ultrasonic Flaw Detector
轴流风机
离心风机
锅炉风机
不锈钢风机
风机

[xc34Elisabetta]

Some people search for the dissertation international just about this good topic. When they get know about your superb research, they would probably order the dissertation writing.

[geshichaunshuo]

[url=http://www.jsylyq.com/ ] 体检车[/url]
[url=http://www.china-dpwj.com ] 家具五金[/url]
[url=http://www.hongd.com/ ] 过滤器[/url]
[url=http://www.hongd.com/ ] 混合器[/url]
[url=http://www.hahxzs.com/ ] 标准柜体[/url]
[url=http://www.hahxzs.com/ ] 烤漆门板[/url]
[url=http://www.tzqs.com/ ] 输送机[/url]
[url=http://www.yylyq.com/ ] 滤油器[/url]
[url=http://www.yylyq.com/ ] 滤油车[/url]
[url=http://www.ntfrp.com/ ] 玻璃钢格栅[/url]
[url=http://www.ntfrp.com/ ] 拉挤型材[/url]
[url=http://www.cnshensuo.com/]织带机[/url]
[url=http://www.ntfyjc.com]平面磨床[/url]
[url=http://www.qdjp.com.cn/qdjp/]静态混合器[/url]
[url=http://www.qdjp.com.cn/qdjp/]煤气静态混合器[/url]
[url=http://www.qdjp.com.cn/qdjp/]自清洗过滤器[/url]
[url=http://www.tongru.com] 电脑绗缝机[/url]
[url=http://www.tongru.com] 开松机[/url]
[url=http://www.dljsj88.com]大棚[/url]
[url=http://www.dljsj88.com]脚手架[/url]
[url=http://www.cnjc.cn/]竹节纱装置[/url]
[url=http://www.cnjc.cn/]永磁电机[/url]
[url=http://www.rftlzp.com/]铝青铜[/url]
[url=http://www.ntstdq.cn/]苏通大桥[/url]
[url=http://www.qdbdwj.cn/]镊子[/url]
[url=http://www.dygyyb.com.cn/]高压油泵[/url]
[url=http://www.dygyyb.com.cn/]柱塞泵[/url]
[url=http://www.jshaixu.com/luqiao/about.asp]路桥工程[/url]
[url=http://www.jshaixu.com/shuhua/about.asp]塑料排水板[/url]
[url=http://www.jshaixu.com/shuhua/about.asp]透明母料[/url]
[url=http://www.jshaixu.com/shuhua/about.asp]塑料消泡剂[/url]
[url=http://www.jshaixu.com/]热熔胶粒[/url]
[url=http://www.mincom.com.cn]玻璃钢格栅[/url]
[url=http://www.mincom.com.cn]玻璃钢盖板[/url]
[url=http://www.flvdvd.com/]Best flv converter[/url]
[url=http://www.flvdvd.com/flv-to-dvd-converter/]Convert FLV to DVD[/url]
[url=http://www.flvdvd.com/flv-converter-for-mac/]FLV Converter for Mac[/url]
[url=http://www.flvdvd.com/flv-video-converter/]FLV to Video Converter[/url]
[url=http://www.flvdvd.com/dvd-ripper-for-mac/]DVD Ripper for Mac[/url]
[url=http://www.flvdvd.com/article.html ]how to convert[/url]
[url=http://www.udtrade.com/category/ultrasonic-flaw-detector/]Ultrasonic Flaw Detector[/url]
[url=http://www.udtrade.com/ultrasonic-flaw-detector/]Technology about Ultrasonic Flaw Detector[/url]
[url=http://www.ntzxfj.cn/ntzxfj/zhouliufengji.htm]轴流风机[/url]
[url=http://www.ntzxfj.cn/ntzxfj/lixinfengji.htm]离心风机[/url]
[url=http://www.ntzxfj.cn/ntzxfj/guolufengji.htm]锅炉风机[/url]
[url=http://www.ntzxfj.cn/ntzxfj/buxiugangfengji.htm]不锈钢风机[/url]
[url=http://www.ntzxfj.cn]风机[/url]

[viagra online]

hello friend excellent post about How to generate an email address from firstname and lastname thanks for sharing!!

[refurbished computers]

It will be a great fun that you will save huge money.