Email address fro list

  • Thread starter Thread starter Liz Cardona
  • Start date Start date
L

Liz Cardona

Hi,

I making a spreadsheet of all the users in my company. How do I auto
populate the next cell so that it takes the first name of the user and add
@domain.com (domain= our email domain) so I don't have to type up all the
e-mail address of my users?

Thanks, Liz
 
It depends on how your list of names is constructed, but if you have
"first_name other_names" in A1 then you can do this:

=LOWER(LEFT(A1,FIND(" ",A1)-1))&"@domain.com"

and copy down.

You will need to decide what to do if you have two or more first names
that are the same.

Hope this helps.

Pete
 
Hi,

I have the first name on one column and the last name on another column.
What is I want the first letter of the name ad last name as an email
address?

Thanks for your help!!!
 
Well, assuming that your first names are in column A and the last
names in column B, you can use this:

=LOWER(TRIM(LEFT(A1,1)&B1))&"@domain.com"

then copy down.

Again, though, you have to cater for two similar names, eg John Smith
and Jane Smith will both give rise to jsmith.

Hope this helps.

Pete
 
Thanks!
The formula works really well!


Well, assuming that your first names are in column A and the last
names in column B, you can use this:

=LOWER(TRIM(LEFT(A1,1)&B1))&"@domain.com"

then copy down.

Again, though, you have to cater for two similar names, eg John Smith
and Jane Smith will both give rise to jsmith.

Hope this helps.

Pete
Click to expand...
 
Hi,

What is I have the name of the person in 1 cell

ex: Jane Doe

How do I manipulate the formula so that it takes the first letter of the
name then the last name.


Thanks, Liz
 
Also, How do I get the fist 10 characters of a cell and replace the last
letter with an underscore?


Thanks, Liz
 
Back
Top