Generating username from first name and last name in excel

0 votes

enter image description here

generate usernames using First Word of first name, Last initial and Last 4 digit of Reference # and with no space or dash.

First Name: John Franklin
 Last Name: Smith Turner    
 Reference: 123456789
     Email: johns6789@example.com <--Generated email all lowercase, no space

=LEFT(A2,FIND(" ",A2)-1)&LEFT(B2,1)&RIGHT(C2,4)&"@example.com"

I tried the following above but works for only the first email but rest shows #VALUE! error

Ty!

Edit: Added a screenshot

Mar 28 in Database by Edureka
• 13,640 points
140 views

1 answer to this question.

0 votes

How to automatically merge first and last names in Excel
Fill in the first and last names manually in an adjacent column for the first entry.
Start entering in the following row's name, and Excel will propose full names for the entire column.
To accept the suggestions, press Enter. Done!

Formula 1: In Excel, combine the first and last names.
Let's imagine you have one column for given name and another for surname in your worksheet, and you want to combine these two columns into one.

Here are the Excel formulas to combine first and last names in their most basic form:

=first_name_cell&" "&last_name_cell
CONCATENATE(first_name_cell," ",last_name_cell)
answered Mar 30 by gaurav
• 13,460 points

Related Questions In Database

0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
87 views
0 votes
1 answer

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
515 views
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15 in Database by gaurav
• 13,460 points
89 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

answered Mar 15 in Database by gaurav
• 13,460 points
40 views
0 votes
1 answer

Hours and minutes difference between two times in Excel

Using the TEXT function in Excel is ...READ MORE

answered Mar 25 in Database by gaurav
• 13,460 points
37 views
0 votes
1 answer

Get month and year from date cells Excel

The steps to modify the date format ...READ MORE

answered Mar 30 in Database by gaurav
• 13,460 points
38 views
0 votes
1 answer

Remove time from date field in Excel formula

Use the Find And Replace function to ...READ MORE

answered Mar 30 in Database by gaurav
• 13,460 points
26 views
0 votes
1 answer

Retrieving Cell name in Excel

ADDRESS(ROW(),COLUMN()) returns the current cell's address, such ...READ MORE

answered Mar 30 in Database by gaurav
• 13,460 points
27 views
0 votes
1 answer

Importing images along with other fields (username,subjectname) from excel in laravel

$objphpexcel = PHPExcel_IOFactory::load("MyExcelFile.xls"); foreach ($objphpexcel ->getSheetByName("My Sheet1")->getDrawingCollection() as ...READ MORE

answered Apr 1 in Database by gaurav
• 13,460 points
281 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by gaurav
• 13,460 points
47 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP