Ask Your Question
0

Generating Email from Name Column

asked 2016-04-07 11:11:02 +0100

Andrew Borg gravatar image

I have a Spreadsheet (LibreOffice) file which includes a Column with Full Names.

I need to extract each name, create an Email address from it and insert it into a another column on the same row.

Email Addresses needs to be created in the form of: NAME.SURNAME@domain.com.

The Name column Includes names such as "Name Surname"

As an Example, if the Name column includes John Doe, I would like LinreOffice Calc to automatically insert John.Doe@domain.com in another Column in the same row.

Is it possible to create a Macro which will automatically parse and insert an Email address from the Name Column?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-04-07 11:28:10 +0100

JohnSUN gravatar image

Formula like as

=HYPERLINK("mailto:"&SUBSTITUTE(TRIM(SUBSTITUTE(A2;"  ";" "));" ";".")&"@domain.com";SUBSTITUTE(TRIM(SUBSTITUTE(A2;"  ";" "));" ";".")&"@domain.com")

work fine for me (without any macro)

edit flag offensive delete link more

Comments

Thanks This Worked.

Would it Be possible to Change the Name with the Email Address inside the Same Cell?

As in, I Enter John Doe and Calc changes to John.Doe@domain.com

Andrew Borg gravatar imageAndrew Borg ( 2016-04-07 12:38:32 +0100 )edit

Okay. And if you mistype? For example write Jonh Deo? Let it be Jonh.Deo@domain.com ? (I mean, that after the correct a mistake macro can transform an address to John.Doe@domain.com@domain.com)

JohnSUN gravatar imageJohnSUN ( 2016-04-07 13:14:30 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-04-07 11:11:02 +0100

Seen: 363 times

Last updated: Apr 07 '16