• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to Separate a Person’s First and Last Name in Excel

December 11, 2022 by Admin Leave a Comment

Here are the formulas for separating first name and last name from a person’s full name. Let us take the following sample data of NBA players

Separate First name and Last Name

Let us first start separating First Name from the Player’s name. Type the this formula in C6 Cell.

=LEFT(B6,FIND(” “,B6))

Separate First Name in Excel

The above formula first finds the single space then Left trims character starting from first character until the start of the single space. Now Autofill this formula for the rest of C6 columns to display the first name.

To get the last name of LeBron James (Cell B6) you can use this formula

=RIGHT(B6,LEN(B6)-FIND(” “,B6) )

What the above formula does is to first get the character count of full name then find starting position of ” “. Then uses RIGHT function to get the characters starting from ” ” till the end of the name. Now drag the formula entered for D6 to rest of the D column.

Separate last name from full name

Filed Under: Excel Tagged With: Excel, First Name, Last Name

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel

blogmines.com Copyright © 2023