@exceltips247: Separate First Name and Last Names - Excel Tips and Tricks Learn how to separate first name and last names. METHOD 1: Using Ctrl + E Here are the steps. 1) Enter first name. 2) Go to any cell below that cell. 3) Ctrl + E 5) Enter last name. 4) Repeat step 2 to 3. This shortcut works in all versions of Excel, from Excel 97 all the way up to Excel 2016. And it works in all types of cells, including cells that contain text, numbers, and formulas. METHOD 2: Using formula Use this formula for first name. =LEFT(A2,(FIND(" ",A2))) Use this formula for last name. =TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255)) How To Pull Or Extract Characters From Right To Left In A Cell Until A Space Is Reached In Excel?, How do you find the space on the right side in Excel?,How do you use right Len and find in Excel?,How do I find spaces in an Excel cell?,How do you find a text from right in Excel?, excel find space in string,how to find space after text in excel,excel find last space in string,excel find second space from right,excel find from right,extract text from right until space,excel extract string from right until character,excel extract text after last space, excel find space in string,excel find from right,how to find space after text in excel,excel find last space in string,excel find second space from right,extract text from right until space, #tips #excel #shorts #shortvideo

ExcelTips247

Open In TikTok:

Region: CA

Sunday 14 June 2026 17:38:40 GMT