Get First Name from Name: Simple Ways

This article explains the most reliable ways to extract a first name from a full name string, whether you are working in Excel, Google Sheets, Python, or just doing it by hand. You will learn the basic split-by-space method, its limitations with middle names and suffixes, and more robust approaches for real-world name data.

Why This Is Harder Than It Looks

Real-world names do not always follow the simple First Last pattern. The naive approach fails in several common situations:

Middle names: “Mary Jane Watson” – the naive method gives “Mary”, which is correct, but if you need the first and middle name together, you need a different rule.
Multiple first names: “Jean-Luc Picard” – the hyphenated first name is usually kept as one unit, but some systems treat it as two.
Titles and prefixes: “Dr. Jane Smith” or “Mr. John Doe” – the naive method returns “Dr.” or “Mr.”, not the actual first name.
Suffixes: “John Smith Jr.” – the naive method still gives “John”, so this is fine for the first name, but if you also extract the last name, you will get “Smith Jr.” unless you handle it.
Single-word names: “Madonna” or “Prince” – the naive method returns the entire string, which is correct.
Names with spaces in the first name: “Mary Ann Smith” – some cultures treat “Mary Ann” as a single first name, so the naive method gives only “Mary”.

These edge cases mean that a simple split is only a starting point. For a one-off task, it is often enough. For a large dataset, you need to consider the source of the data and what conventions it follows.

How to Do It in Excel and Google Sheets

Both Excel and Google Sheets offer text functions that can extract the first word.

Excel: =LEFT(A1, FIND(" ", A1) - 1) – this finds the position of the first space and returns the characters to its left. If there is no space, FIND returns an error, so you might wrap it in IFERROR: =IFERROR(LEFT(A1, FIND(" ", A1) - 1), A1).
Google Sheets: The same formula works, but you can also use =SPLIT(A1, " ") which creates an array of words; the first element is the first name. To get just the first element, use =INDEX(SPLIT(A1, " "), 1).

Both approaches are case-sensitive when finding the space, but that does not matter here. They also treat multiple consecutive spaces as separate delimiters, which can cause issues if your data has extra spaces. To handle that, use the TRIM function first: =LEFT(TRIM(A1), FIND(" ", TRIM(A1)) - 1).

How to Do It in Python and Other Languages

In Python, the standard approach is:

name = "John Smith"
first_name = name.split()[0]
print(first_name)  # John

The split() method with no arguments splits on any whitespace and ignores leading/trailing spaces. This is generally more robust than splitting on a single space. In JavaScript, you would write:

const name = "John Smith";
const firstName = name.trim().split(/\s+/)[0];
console.log(firstName); // John

The regular expression /\s+/ splits on one or more whitespace characters, which handles extra spaces. In SQL, you might use SUBSTRING_INDEX(name, ' ', 1) in MySQL, or SPLIT_PART(name, ' ', 1) in PostgreSQL. These all follow the same logic.

Handling Middle Names and Suffixes

If your data includes middle names, you have to decide what counts as the “first name”. For most Western names, the first word is the first name, and the middle name is a separate word. But if you want to extract the first and middle name together (e.g., for a salutation like “Dear Mary Jane”), you need a different rule.

First name only: take the first word.
First and middle names: take all words except the last one. This assumes the last word is the last name, which is not always true for names with suffixes.
First name, middle initial: take the first word and the first letter of the second word, if it exists.

Suffixes like “Jr.”, “Sr.”, “II”, “III” are usually at the end. If you are extracting the last name, you need to remove the suffix first. A common pattern is to check if the last word is a known suffix and, if so, use the word before it as the last name. This is not foolproof, but it works for most English-language data.

Common Mistakes and Pitfalls

Assuming exactly one space: Names with double spaces, tabs, or non-breaking spaces will break the simple split. Always trim and normalize whitespace first.
Forgetting titles: “Dr. John Smith” – the naive method gives “Dr.”. If your data has titles, you need to strip them first or use a list of common titles to ignore.
All-caps or lowercase: The extraction itself is case-insensitive, but if you need the name in proper case, you may need to apply a separate function like PROPER() in Excel.
Non-Western name orders: In many East Asian cultures, the family name comes first (e.g., “Lee Min-ho” – Lee is the family name). If your data is international, the simple “first word” rule is wrong for those names.
Using a fixed character count: Some people try =LEFT(A1, 5) to get the first 5 characters. This only works if all first names have exactly 5 characters, which is never the case.

Frequently Asked Questions

What if the name has a middle name?

The simple method still returns the first name correctly, because the middle name comes after a space. For example, “Mary Jane Watson” gives “Mary”. If you need “Mary Jane”, you would take all words except the last one.

How do I get the first name when there is a title like “Dr.”?

You need to remove the title first. You can use a formula like =IF(LEFT(A1,3)="Dr.", MID(A1,4,LEN(A1)), A1) to strip a known prefix, but this gets messy. A better approach is to clean the data before extraction, or use a list of common titles to exclude.

Does this work for names like “Jean-Luc”?

Yes, the hyphenated name is treated as a single word because there is no space. The result is “Jean-Luc”. If you want to split it into “Jean” and “Luc”, you would need a separate step that splits on hyphens.

What about names with suffixes like “John Smith Jr.”?

The first name extraction is unaffected – you still get “John”. However, if you also extract the last name, you would get “Smith Jr.” unless you remove the suffix. A common approach is to check if the last word is in a list of suffixes and, if so, use the second-to-last word as the last name.

Is there a way to handle names where the first name has a space, like “Mary Ann”?

There is no universal way to know if “Mary Ann” is a single first name or a first and middle name. You need a rule based on your data. If you know that all first names in your dataset are either one or two words, you could take the first two words. Otherwise, you may need to use a reference list of common compound first names.

What if the name is in all caps or has unusual capitalization?

The extraction method does not care about capitalization. If you want to convert the result to proper case, use =PROPER(...) in Excel or Sheets, or .title() in Python. Be aware that .title() will capitalize the letter after a hyphen, which is usually what you want.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →