Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to calculate average last N values in a table in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Reverse List in Excel
  • How to Create Gantt Chart in Excel
  • How to create Gauge Chart in Excel

References

  • Merge tables with VLOOKUP in Excel
  • Vlookup Examples in Excel
  • How to reference named range different sheet in Excel
  • How to get address of first cell in range in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation must begin with
  • Excel Data validation date in next 30 days
  • Excel Data validation allow uppercase only
  • Excel Data validation with conditional list

How to create email address from name in Excel

by

To build email addresses using first and last names, you can use a formula that concatenates values, with help from the LOWER and LEFT functions as needed. See example below:

Formula

=LOWER(LEFT(first)&last)&"@domain.com"
How to create email address from name in Excel

Explanation

In the example shown, the formula in D5 is:

=LOWER(LEFT(C5)&B5)&"@"&"acme.com"

How this formula works

For a name like “Tim Brown”, this formula builds an email address like “tbrown@domain.com”.

Worked Example:   Split numbers from units of measure in Excel

First, the LEFT function is used to get the first letter from the first name in column C. Usually, the LEFT function gets a “num_chars” value for the second argument, but the argument is optional and defaults to 1 if omitted.

LEFT(C5) // get first character from first name

The first letter of the first name is then joined to the last name using the concatenation operator (&), and the result is wrapped in the LOWER function, which forces all text to lower case.

LOWER(LEFT(C5)&B5) // lower case

Finally, result is jointed again to “@” and then to the domain. The domain is kept separate for convenience only. The formula could be written like this:

Worked Example:   LEFT, LEFTB functions: Description, Usage, Syntax, Examples and Explanation

With a named range

To simply the formula, you could create a named range “domain” to hold the domain name, then rewrite the formula like this:

=LOWER(LEFT(first)&last)&domain

Changing the value in the named range will then update all email addresses at once.

Worked Example:   How to strip protocol and trailing slash from URL in Excel

Post navigation

Previous Post:

How to extract domain name from URL in Excel

Next Post:

How to create email address with name and domain in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Complete List of Excel Logical Functions, References and Examples
  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel TRUE Function
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function

Date Time

  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • Sum race time splits in Excel
  • Calculate days remaining in Excel
  • Display Date is workday in Excel
  • Add days to date in Excel

Grouping

  • Map text to numbers in Excel
  • Running count group by n size in Excel
  • Group arbitrary text values in Excel
  • How to randomly assign people to groups in Excel
  • Group times into 3 hour buckets in Excel

General

  • Using Existing Templates in Excel
  • How to fill cell ranges with random text values in Excel
  • Convert column letter to number in Excel
  • Split Cell Content Using Text to Columns in Excel
  • How to calculate percent of students absent in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning