How to extract names from email adress

Hello,

I want to extract the name of team member from an email adress, which I get as entry from the system in my sheet.

for example: joachim.armbruster@xxxxxxx.com it should be writte in another cell: Joachim Armbruster

I tried following formula:

=UPPER(LEFT([Mitarbeiter_System]@row)) + (MID([Mitarbeiter_System]@row, 2, 1) + MID([Mitarbeiter_System]@row), 3, FIND("@", [Mitarbeiter_System]@row) - 3))

but it does not work

many thanks and regards

Joachim

Find more posts tagged with

Accepted answers

Johnathan Vargas Cruz

=UPPER(LEFT([Mitarbeiter_System]@row,FIND(".",[Mitarbeiter_System]@row,1)-1) + " " + MID([Mitarbeiter_System]@row, FIND(".", [Mitarbeiter_System]@row, 1) + 1, FIND("@", [Mitarbeiter_System]@row) - FIND(".", [Mitarbeiter_System]@row) - 1)

This should do what you want. It splits the string on "." and "@" giving you the information in between as a single string with a " " in between for readability.

All comments

Johnathan Vargas Cruz

This should do what you want. It splits the string on "." and "@" giving you the information in between as a single string with a " " in between for readability.

Antonio Figueroa

Try this. Change Column12 to your column and it should work.

=LEFT([Column12]@row, FIND(".", [Column12]@row, 1) - 1) + " " + LEFT(RIGHT([Column12]@row, LEN([Column12]@row) - VALUE(FIND(".", [Column12]@row))), FIND("@", RIGHT([Column12]@row, LEN([Column12]@row) - VALUE(FIND(".", [Column12]@row)))) - 1)

Joachim Armbruster

Many thanks for your quick and useful answers. Both solutions work.

best regards

Joachim

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.