+ Reply to Thread
Results 1 to 3 of 3

Extracting 1st name in a string of names ?

  1. 08-30-2021, 12:39 PM #1
    Ron Purpura
    Ron Purpura is offline
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Extracting 1st name in a string of names ?

    Hello All
    I was wondering if there was a formula to help me extract the 1st name that appears in a string of names in a cell? I know I can use the TEXT TO COLUMNS function, but not always useful on the data set I am working with

    In the Attached example, I would like to have the first name in the string of names in cell A2 to Appear in Cell B2 The names are separated by the semi colon

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-30-2021, 12:54 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,408

    Re: Extracting 1st name in a string of names ?

    Try

    =LEFT(A2,FIND(";",A2)-1)
    Reply With QuoteRegister To Reply
  3. 08-30-2021, 01:01 PM #3
    Ron Purpura
    Ron Purpura is offline
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: Extracting 1st name in a string of names ?

    Perfect ! Thank you John !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. extracting volunteer names
    By ameseattle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2020, 08:02 PM
  2. Extracting names formula
    By jaysjay in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2016, 10:23 PM
  3. Extracting Letter/Number from Alphanumeric string (4 different times from same string)
    By dextercr in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-20-2013, 05:46 PM
  4. Pulling out single names from a string of names
    By HBF in forum Excel General
    Replies: 4
    Last Post: 02-23-2013, 08:25 AM
  5. [SOLVED] Extracting tab names
    By MLK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2006, 03:55 PM
  6. [SOLVED] Extracting worksheet names....
    By johnT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-04-2005, 10:06 AM
  7. Extracting names in a cell
    By bbc1 in forum Excel General
    Replies: 3
    Last Post: 02-13-2005, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1