跳到主要內容

如何在Excel中將相同的電子郵件地址添加到姓名列表中？

現在，當您在一列中有一些聯繫人的名字，而在另一列中有姓氏時，您想要通過將他們的名字和姓氏組合為用戶名並使用相同的電子郵件域來為每個聯繫人創建電子郵件地址，例如google.com，如何快速創建電子郵件地址？ 本文為您展示了一些快速技巧。

在Excel中使用公式將相同的電子郵件地址添加到名稱中

使用Kutools for Excel將相同的電子郵件地址添加到名稱中好主意3

在Excel中使用公式將相同的電子郵件地址添加到名稱中

如果A列中的名字，B列中的名字，並且您想為這些名字創建相同的電子郵件地址，請執行以下操作：

1。 打字 = CONCATENATE（A1，“。”，B1，“ @ google.com”） 在單元格C1中，請參見屏幕截圖：

2。 按 Enter 鍵，然後拖動右填充手柄以填充範圍。 看截圖：

注意：你可以改變 “，” 和 “ google.com” 滿足您的需求。 例如，輸入 =CONCATENATE（A1，“”，B1，“ @ yahoo.cn”），請參見屏幕截圖：

如果需要將電子郵件添加為超鏈接，則可以鍵入公式 = HYPERLINK（A1＆B1＆“ @ google.com”），請參見屏幕截圖：

然後按 Enter 按鈕，然後拖動右填充手柄以填充範圍。 看截圖：

注意：你可以改變 “ google.com” 滿足您的需求。

使用Kutools for Excel將相同的電子郵件地址添加到名稱中

這款獨特的敏感免洗唇膜採用 Moisture WrapTM 技術和 Berry Mix ComplexTM 成分， Excel的Kutools 安裝後，您可以先組合名字和姓氏，然後添加相同的電子郵件地址。

Excel的Kutools, 與以上 300 方便的功能，使您的工作更加輕鬆。 
免費下載
30 天內免費提供全功​​能

後 免費安裝 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選項卡為Office帶來了選項卡式界面，使您的工作更加輕鬆

  • 在Word，Excel，PowerPoint中啟用選項卡式編輯和閱讀，發布者，Access，Visio和Project。
  • 在同一窗口的新選項卡中而不是在新窗口中打開並創建多個文檔。
  • 將您的工作效率提高 50%，每天為您減少數百次鼠標點擊！
Comments (14)
No ratings yet. Be the first to rate!
Mushhaf
Mushhaf
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.
Reply
0
0
Tom
Tom
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? 
Reply
0
0
Sunny
Sunny     Tom
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.
Reply
Report
0
0
Vanessa
Vanessa
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.
Reply
0
0
Sunny
Sunny     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.
Reply
Report
0
0
mike.johnson.usg@gmail.com
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
View Attachments (1 / 5)
Reply
Report
0
0
Sunny
Sunny    
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
View Attachments (1 / 5)
Reply
Report
0
0
Mike johnson
Mike johnson
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
Reply
0
0
roll the ball
roll the ball
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
Reply
0
0
Sebastian
Sebastian
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
Reply
0
0
Sunny
Sunny     Sebastian
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.
View Attachments (1 / 5)
Reply
Report
0
0
Satheesh
Satheesh
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
Reply
0
0
Sunny
Sunny     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.
Reply
Report
0
0
Roshan Rajak
Roshan Rajak
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.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations