I am trying to find a way to generate email addresses from the first name and the first letter of a last name. I used the CONCATENATE function, but it will only take a full cell, not a first letter.
Google-sheets – function in Google Sheets to extract the first letter of a text in a cell
formulasgoogle sheets
Related Solutions
=CONCATENATE(A1,".",B1,"@company.com") will do exactly what you want:
It may not be the prettiest answer, but you can also combine a few concat() functions together to get =CONCAT(CONCAT(CONCAT(A1,"."),B1),"@company.com") to do this:
The following are three distinct characters:
" 34
“ 8220
” 8221
and although the help file for IMPORTRANGE mentions only ...either be enclosed in quotation marks or be a reference to a cell containing... the required quotation marks are the "straight" ones.
So just use ".
Related Topic
- Google-sheets – Identifying a merged cell in Google Sheets without using a custom function
- Google Sheets – How to Check if the First Letter in a Cell is Uppercase
- Google-sheets – Concatenate using an array formula to result in last name.firstname
- Google-sheets – How to stop new text in a cell overlapping the old text in Google Sheets
- Google Sheets – How to Include Text from a Cell within a COUNTIF Function
- Google-sheets – Preserve leading zeros in a Google Sheets CONCATENATE function
Best Answer
You may use
REGEXTRACT. See the example below:Here is another example: