跳到主要内容

如何在Excel中将相同的电子邮件地址添加到姓名列表中?

现在,当您在一列中有一些联系人的名字,而在另一列中有姓氏时,您想要通过将他们的名字和姓氏组合为用户名并使用相同的电子邮件域来为每个联系人创建电子邮件地址,例如google.com,如何快速创建电子邮件地址? 本文为您展示了一些快速技巧。

在Excel中使用公式将相同的电子邮件地址添加到名称中

使用 Kutools for Excel 将相同的电子邮件地址添加到姓名中好主意3


在Excel中使用公式将相同的电子邮件地址添加到名称中

如果A列中的名字,B列中的名字,并且您想为这些名字创建相同的电子邮件地址,请执行以下操作:

1.打字 = CONCATENATE(A1,“。”,B1,“ @ google.com”) 在单元格C1中,请参见屏幕截图:

2。 按 输入 键,然后拖动右填充手柄以填充范围。 看截图:

注意:你可以改变 “,” “ google.com” 满足您的需求。 例如,输入 =CONCATENATE(A1,“”,B1,“ @ yahoo.cn”),请参见屏幕截图:

如果需要将电子邮件添加为超链接,则可以键入公式 = HYPERLINK(A1&B1&“ @ google.com”),请参见屏幕截图:

然后按 输入 按钮,然后拖动右填充手柄以填充范围。 看截图:

注意:你可以改变 “ google.com” 满足您的需求。


使用 Kutools for Excel 将相同的电子邮件地址添加到姓名中

Kutools for Excel 安装后,您可以先组合名字和姓氏,然后添加相同的电子邮件地址。

Kutools for Excel, 与超过 300 方便的功能,使您的工作更加轻松。 

免费安装 Kutools for Excel,请执行以下操作:

1.选择要添加电子邮件地址的所有名称,然后单击 库工具 > 合并与拆分 > 合并行,列或单元格而不会丢失数据。 查看屏幕截图:
doc添加相同的电子邮件地址01

2.然后在 弹出对话框,执行以下操作。

doc添加相同的电子邮件地址02
(1)检查 合并栏;

(2)检查 余位 in 指定分隔符 部分;

(3)指定要放置结果的位置;

(4)选择所需的合并选项。

3。 点击 Ok,然后选择合并单元格,然后单击 库工具 > 文本 > 添加文本。 看截图:
文档库工具 1

4.在 添加文本 对话框中,只需在的文本框中输入所需的电子邮件地址 文本,然后检查 最后一个字符之后。 看截图:doc添加相同的电子邮件地址04

5。 点击 Ok。 现在,电子邮件已添加到名称中。
doc添加相同的电子邮件地址05

想了解如何 结合请点击 结合.

最佳办公生产力工具

🤖 Kutools 人工智能助手:基于以下内容彻底改变数据分析: 智能执行   |  生成代码  |  创建自定义公式  |  分析数据并生成图表  |  调用 Kutools 函数...
热门特色: 查找、突出显示或识别重复项   |  删除空白行   |  合并列或单元格而不丢失数据   |   不使用公式进行四舍五入 ...
超级查询: 多条件VLookup    多值VLookup  |   跨多个工作表的 VLookup   |   模糊查询 ....
高级下拉列表: 快速创建下拉列表   |  依赖下拉列表   |  多选下拉列表 ....
列管理器: 添加特定数量的列  |  移动列  |  切换隐藏列的可见性状态  |  比较范围和列 ...
特色功能: 网格焦点   |  设计图   |   大方程式酒吧    工作簿和工作表管理器   |  资源库 (自动文本)   |  日期选择器   |  合并工作表   |  加密/解密单元格    按列表发送电子邮件   |  超级筛选   |   特殊过滤器 (过滤粗体/斜体/删除线...)...
前 15 个工具集12 文本 工具 (添加文本, 删除字符,...)   |   50+ 图表 类型 (甘特图,...)   |   40+ 实用 公式 (根据生日计算年龄,...)   |   19 插入 工具 (插入二维码, 从路径插入图片,...)   |   12 转化 工具 (小写金额转大写, 货币兑换,...)   |   7 合并与拆分 工具 (高级组合行, 分裂细胞,...)   |   ... 和更多

使用 Kutools for Excel 增强您的 Excel 技能,体验前所未有的效率。 Kutools for Excel 提供了 300 多种高级功能来提高生产力并节省时间。  单击此处获取您最需要的功能...

产品描述


Office Tab 为 Office 带来选项卡式界面,让您的工作更加轻松

  • 在Word,Excel,PowerPoint中启用选项卡式编辑和阅读,发布者,Access,Visio和Project。
  • 在同一窗口的新选项卡中而不是在新窗口中打开并创建多个文档。
  • 每天将您的工作效率提高50%,并减少数百次鼠标单击!
Comments (14)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Mau nanya.

saya Ada Customer anggap saja Namanya A.
Tapi Customer A ini mempunyai 2 PIC dan masing masing punya email.
Nah untuk Alamat emailnya ini apakah bisa diketik dalam 1 Cell yang mencakup 2 emailnya atau 1 email harus 1 Cell ??
Karena rencana saya mau buat Pesan Otomatis ke PIC masing masing.
kalau memang beberapa alamt email bisa diketik dalam 1 cell itu pemisalhnya simbol apa agar semua email bisa aktif dalam 1 cell tersebut.

dan Untuk Customer ada beberapa ya.
This comment was minimized by the moderator on the site
Question, I have a project where I have last name Petterson and First name Steven-Marco. I need to make an email address that goes . How do you cut the -Marco part with a single formula? 
This comment was minimized by the moderator on the site
Hi, Tom, supposing your first name Steven-Marco in cell A1, please use the formula =LEFT(A1,(FIND("-",A1,1)-1)) to extract Steven only. This formula extract the string before "-" from the cell. Hope this help you.
This comment was minimized by the moderator on the site
Hi,
My name is Vanessa and i work for the sales dept. in my organization. My job demands to send hundreds of email everyday.

Can anyone help me to create email ids for different companies/domains. I have a list of few companies and all have different formats of email ids.
I know the email id formats of all the companies, however, don't waste to spend time creating emails everyday. Is there a way to run a macro in such a way that i just provide the name of the company and first name and last name of multiple people and have the email ids ready?
Thanks in Advance
Vanessa.
This comment was minimized by the moderator on the site
hi,Vanessa,list all companies, first names and last names in separate three columns, then in a blank column which you want to get the email, type this formula =L1&"_"&M1&"_"&N1&"@google.com",L1 is the company name, M1 is the first name, N1 is the last name, _ is the connector, @google.com is the email format you use.
This comment was minimized by the moderator on the site
Hi,
This is mike please can any one help me sorting the email ids with the names.

can one guide me how to sort this email id with name

thank in advance

Regards,

Mike Johnson
This comment was minimized by the moderator on the site
Hello,do you mean to sort email based on the name in column A as below picture shown? If so, I have no idea
This comment was minimized by the moderator on the site
Hi there,

Please any one can help in sorting this type of emails with names in excel, i m trying but its not at all possible to match this email ids with name( match the email id with possible matching letters in name) Please help me any one

Blank --------------

Blank ----------------

Blank----------- Sheikh kam

Blak______ Mike john



In this order how can place the email ids in exact position in excel...


Thanks for the help in advance.

Mike johnson
This comment was minimized by the moderator on the site
Thank you for sharing this article with us! I believe there will be more people like me, they can find many interesting things in this article of you!
- impossible game - roll the ball
This comment was minimized by the moderator on the site
Hi, great tip!


Question; is there a way to automatically switch out "forbidden" characters in the email? For example, swedish uses three characters not allowed in the address but they will be written out in the name. When we have names with these three letters Å, Ä and Ö, we replace them in mails and websites with A, A and O. This is what i'd like to do...



Regards
This comment was minimized by the moderator on the site
Sorry, I have not found the automatical way. But you can apply th Find and Replace function by pressing Ctrl + H to find the characters and then replace. Or you can apply Kutools for Excel's Prevet Typing feature to forbid some characters entering.
This comment was minimized by the moderator on the site
Hello, Is there any possible to duplicate the names N-times through excel.. If so please can you explain how to make it. I need like below. Satheesh Satheesh Satheesh Satheesh Satheesh Satheesh
This comment was minimized by the moderator on the site
Hello, if you want to repeat a names based on a column as below screenshot shown, this article https://www.extendoffice.com/documents/excel/1897-excel-repeat-cell-value-x-times.html may give you a satisfied answer. If not, please describe ur queston with more details. Thank u.
This comment was minimized by the moderator on the site
Thank you so much for this blog. This blog solved my all the problems which i was having since 6 months. Thank you keep posting other tricks.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations