Email address fro list

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
 
P

Pete_UK

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
 
L

Liz Cardona

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!!!
 
P

Pete_UK

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
 
L

Liz Cardona

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...
 
L

Liz Cardona

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
 
L

Liz Cardona

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


Thanks, Liz
 
Top