In the example shown, the formula in D5 is: The LEFT function is normally configured with num_chars, but the argument is optional and left will extract 1 character from the left when it is absent. This results in the text string “atanaka”. Next, the domain name is added like this: Note that the reference to the domain name is absolute ($G$6) so that the formula can be copied down the table without this reference changing. Finally, the lower function is used to lowercase the entire string: which returns a final result of “atanaka@acme.com”
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
