How to Get the First Name from the Full Name In Excel Office 365?
Tags: excelpreface, excelbasics, exceltutorials, getfirstnamefromfull
Published: 2021-01-18 03:56:51

---
title: How to Get the First Name from the Full Name In Excel Office 365?
published: true
date: 2021-01-08 14:12:57 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Getfirstnamefromfull
canonical_url: https://geekexcel.com/get-first-name-from-full-name-excel/
---

Suppose you have a name list, and you need to **get the first name from the full name**. How can you find them quickly? Here are some tricky methods to help you to solve this problem. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to Extract the First name:

To get the first name from a full name list, you can use the [**LEFT**](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/) function along with the [**FIND**](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/) function.

- **LEFT** – It extracts the first character (starting from the left side) or characters from the given string based on the number you specified.
- **FIND** – This function will find out the location of the text and returns the position as a number.

### Example:

Just follow the below steps to get the first name from the full name in Excel.

- First, we will give the input names in [**Column**](https://geekexcel.com/excel-office-365-columns/) **B**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-1.png)<figcaption id="caption-attachment-20821">Input Range</figcaption>

- Here, the full name is separated by the space character. So we need to get the position of the first space character using the below formula.

**=[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(” “,B3)**

![Get first position](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Get-first-position.png)<figcaption id="caption-attachment-20822">Get first position</figcaption>

- After **[entering the formula](https://geekexcel.com/how-to-enter-formula-in-excel/)** you can get the position of the first space character.
- You need to enter the given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section to get the first name from the list.

**=[LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(B3,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(” “,B3)-1)**

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-4.png)<figcaption id="caption-attachment-20823">Enter a formula</figcaption>

- In this formula the **LEFT** function will extract the leftmost characters based on the numeric position returned by the **FIND** function.
- After applying the formula you can get the result in the selected [**cell**](https://geekexcel.com/excel-cells-options/).

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-12.png)<figcaption id="caption-attachment-20824">Result</figcaption>

## Conclusion:

In the above article, we have provided simple and quick steps to **get the first name from the text string in Excel**. Found that this article is useful? Then leave your **feedback** in the below **comment** box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)**

### Read Also:

- **[Excel Formulas to Get the First Text Value in A List or Range!!](https://geekexcel.com/get-the-first-text-value-excel/)**
- **[Excel Shortcut to Extend Selection to First Cell in Worksheet!!](https://geekexcel.com/ms-excel-shortcut-to-extend-selection-to-first-cell-in-worksheet/)**