Forum Discussion
Need help combining columns to export email group to outlook
I have 3 columns I'd like to combine so I can export them and create a contact group in Outlook. ="Brown, James Andrew" ="R2.D2" '@school.org I'd like to combine columns B and C to create a...
Assuming you have John in cell B2 and Smith in cell C2, and you want to add suffix @pcsb.org.. Follow the steps below
=LOWER(CONCATRNATE(B2,".",C2,"@pcsb.org"))
Or you can use =LOWER(B2&"."&C2&"@pcsb.org")
Both method will deliver john.smith@pcsb.org
=LOWER(CONCATRNATE(B2,".",C2,"@pcsb.org"))
Or you can use =LOWER(B2&"."&C2&"@pcsb.org")
Both method will deliver john.smith@pcsb.org
Thank you for your reply. The cells are as above. A1 is Brown, James Arthur B1 is R2.D2 C1 is @pcsb.org
Columns A & B are as imported from our grading software. I'm trying to add the pcsb.org to complete the email address as mailto:R2.D2@pcsb.org I'm thinking the comma between the names and the period in between R2 and D2 of the email address could be a problem?
I have not attempted this before but I believe Outlook needs just name, address separated by a comma.
- =LOWER(B1&C1)
That will deliver r2 d2@pcsb.off
Or
=B1&C1
It will deliver R2.D2@pcsb.org
Is that what you want
