Preskoči na glavno vsebino

Kako dodati isti e-poštni naslov na seznam imen v Excelu?

Ko imate v stolpcu imena nekaterih stikov in priimke v drugem stolpcu, zdaj , želite za vsakega ustvariti e-poštne naslove tako, da njihova imena in priimke združite kot uporabniška imena in uporabite isto e-poštno domeno, na primer google.com, kako lahko hitro ustvarite e-poštne naslove? Ta članek prikazuje hitre trike za vas.

Imenom s formulo v Excelu dodajte isti e-poštni naslov

Imenom dodajte enak e-poštni naslov s programom Kutools za Exceldobra ideja3


Imenom s formulo v Excelu dodajte isti e-poštni naslov

Če imena v stolpcu A, priimki v stolpcu B in želite ustvariti enak e-poštni naslov za imena, storite naslednje:

1. Tipkanje = CONCATENATE (A1, ".", B1, "@ google.com") v celici C1 si oglejte posnetek zaslona:

2. Pritisnite Vnesite in nato povlecite desni ročaj za polnjenje, da zapolnite obseg. Oglejte si posnetek zaslona:

Opomba:Lahko se spremeniš "" in "google.com" da izpolnimo, kar potrebujete. Na primer tipkanje =CONCATENATE (A1, "", B1, "@ yahoo.cn"), glej posnetek zaslona:

Če morate e-poštna sporočila dodati kot hiperpovezave, lahko vnesete formulo = HYPERLINK (A1 & B1 & "@ google.com"), glej posnetek zaslona:

Nato pritisnite Vnesite in nato povlecite desni ročaj za polnjenje, da zapolnite obseg. Oglejte si posnetek zaslona:

Opomba:Lahko se spremeniš "google.com" da izpolnimo, kar potrebujete.


Imenom dodajte enak e-poštni naslov s programom Kutools za Excel

z Kutools za Excel nameščen, lahko najprej kombinirate ime in priimek, nato pa dodate isti e-poštni naslov.

Kutools za Excel, z več kot 300 priročne funkcije, vam olajša delo. 

po brezplačna namestitev Kutools za Excel, naredite spodaj:

1. Izberite vsa imena, ki jim želite dodati e-poštni naslov, in kliknite Kutools > Spoji in razdeli > Združite vrstice, stolpce ali celice brez izgube podatkov. Oglejte si posnetke zaslona:
doc dodaj isti e-poštni naslov 01

2. Nato v Pojavi se pogovorno okno, naredite spodaj.

doc dodaj isti e-poštni naslov 02
(1) Preverite Združite stolpce;

(2) Preverite Prostori in Navedite ločilo odsek;

(3) Določite položaj, kamor želite postaviti rezultat;

(4) Izberite želeno kombinacijo.

3. klik Ok, nato ohranite izbrane celice združevanja in kliknite Kutools > Besedilo > dodajanje besedila. Oglejte si posnetek zaslona:
doc kutools 1

4. V Ljubljani dodajanje besedila pogovorno okno, samo vnesite želeni e-poštni naslov v besedilno polje Besedilo, nato preverite Po zadnjem znaku. Oglejte si posnetek zaslona:doc dodaj isti e-poštni naslov 04

5. klik Ok. zdaj so imen dodana e-poštna sporočila.
doc dodaj isti e-poštni naslov 05

Za več informacij o Združite, Kliknite Združite.

Najboljša pisarniška orodja za produktivnost

Priljubljene funkcije: Poiščite, označite ali identificirajte dvojnike   |  Izbriši prazne vrstice   |  Združite stolpce ali celice brez izgube podatkov   |   Krog brez formule ...
Super iskanje: Več kriterijev VLookup    Multiple Value VLookup  |   VLookup na več listih   |   Nejasno iskanje ....
Napredni spustni seznam: Hitro ustvarite spustni seznam   |  Odvisni spustni seznam   |  Večkrat izberite spustni seznam ....
Upravitelj stolpcev: Dodajte določeno število stolpcev  |  Premakni stolpce  |  Preklop stanja vidnosti skritih stolpcev  |  Primerjaj obsege in stolpce ...
Predstavljene funkcije: Mrežni fokus   |  Pogled oblikovanja   |   Velika vrstica formule    Upravitelj delovnih zvezkov in listov   |  Knjižnica virov (Samodejno besedilo)   |  Izbirnik datuma   |  Združite delovne liste   |  Šifriranje/dešifriranje celic    Pošljite e-pošto po seznamu   |  Super filter   |   Poseben filter (filter krepko/ležeče/prečrtano ...) ...
15 najboljših kompletov orodij12 Besedilo Orodja (dodajanje besedila, Odstrani znake,...)   |   50 + Graf Vrste (Gantt Chart,...)   |   40+ Praktično Formule (Izračunajte starost glede na rojstni dan,...)   |   19 vstavljanje Orodja (Vstavite kodo QR, Vstavi sliko s poti,...)   |   12 Pretvorba Orodja (Številke v besede, Pretvorba valut,...)   |   7 Spoji in razdeli Orodja (Napredne kombinirane vrstice, Razdeljene celice,...)   |   ... in več

Napolnite svoje Excelove spretnosti s Kutools za Excel in izkusite učinkovitost kot še nikoli prej. Kutools za Excel ponuja več kot 300 naprednih funkcij za povečanje produktivnosti in prihranek časa.  Kliknite tukaj, če želite pridobiti funkcijo, ki jo najbolj potrebujete...

zavihek kte 201905


Kartica Office prinaša vmesnik z zavihki v Office in poenostavi vaše delo

  • Omogočite urejanje in branje z zavihki v Wordu, Excelu, PowerPointu, Publisher, Access, Visio in Project.
  • Odprite in ustvarite več dokumentov v novih zavihkih istega okna in ne v novih oknih.
  • Poveča vašo produktivnost za 50%in vsak dan zmanjša na stotine klikov miške za vas!
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