Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Approximate match with multiple criteria in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Count rows with at least n matching values
  • Left Lookup in Excel
  • How to use Excel MMULT Function

Data Analysis Examples

  • How to Create Thermometer Chart in Excel
  • Randomize/ Shuffle List in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to create a Histogram in Excel
  • Excel Line Chart

Data Validation Examples

  • Excel Data validation whole percentage only
  • How To Create Drop-down List in Excel
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year
  • Excel Data validation with conditional list

Get first name from full name — Manipulating NAMES in Excel

by

If you need extract the first name from a full name, you can easily do so with the FIND and LEFT functions. In the  formula below, name is a full name, with a space separating the first name from other parts of the name.

Note: this formula does not account for titles (Ms., Mr., etc) in the full name. If titles exist, they should be removed first.

Worked Example:   Count cells that contain specific text in Excel

Formula

=LEFT(name,FIND(" ",name)-1)

Explanation

In the example, the active cell contains this formula:

=LEFT(B4,FIND(" ",B4)-1)

How this formula works

The FIND function finds the first space character (” “) in the name and returns the position of that space in the full name. The number 1 is subtracted from this number to account for the space itself. This number is used by the LEFT function as the total number of characters that should be extracted in the next step below. In the example, the first space is at position 6, minus 1, equals 5 characters to extract.

Worked Example:   How to extract word containing specific text in Excel

The LEFT function extracts characters from the full name starting on the left and continuing up to the number of characters determined in the previous step above. In the example, 5 is the total number of characters, so the result is “Susan”.

Worked Example:   Excel Data validation must contain specific text

Post navigation

Previous Post:

Get first name from name with comma — Manipulating NAMES in Excel

Next Post:

Extract last name from full name — Manipulating NAMES in Excel

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove text by position in a cell in Excel
  • How to count specific words in a range in Excel
  • BAHTTEXT function: Description, Usage, Syntax, Examples and Explanation
  • Replace one character with another in Excel
  • Get last name from name with comma — Manipulating NAMES in Excel
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate percent of year complete in Excel
  • Get day name from date in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Generate series of dates by weekends in Excel
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate original loan amount in Excel
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles