google sheets
I'm creating a database of individuals in a company in Google Sheets. I'm collecting the persons email address, first name, last name all in different columns. The email addresses for all these people always use the same syntax, first.last@company.com.
Is it possible to create a function in Google Sheets that will auto generate the email address based on data entered in the "First name" and "Last name" columns?
Yes. It is Possible. Just follow some simple steps:
A new window will openup and choose spreadsheet option .Here,you can write custom functions which looks like
Here you write functions (for more info,https://developers.google.com/apps-script/your_first_script#requirements)
2.You create a function that will open your Spreadsheet that contains behaves like directory. A sample function
function readRows()
{
var sheet = SpreadsheetApp.openById("0AszINz88nA9hdEkxa1FIS0wta1FLS2NPUzAyU0lOV1E")
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
var values = rows.getValues();
for (var i = 0; i <= numRows - 1; i++) { var row = values[i]; Logger.log(row); } };
For more info,https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#open(File)
You can Run and Test by pressing Run and selecting function, (it may require permission).
You can view the results in Log Window by Opening View->Logs.
That,it now you can use that function in that cell.
this could be solved in many ways, one of which is:
=IMPORTRANGE("URL-of-your-spreadsheet"; "Sheet1!A:Z")
Best Answer
=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: