+ Reply to Thread
Results 1 to 4 of 4

Using IF and LEFT formulas to extract uneven information

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    76

    Using IF and LEFT formulas to extract uneven information

    Hi,

    Thanks for taking the time to see if you can help.

    In one column, I have doctor's names (Dr. P. Schwarts, license #...., etc.) and (Dr. S. L. Jenson, license #....etc.). As you can see, some have one initial and some have two. What I
    really need to do is extract the doctor's name BEFORE the "," which lists the doc's license and other information.

    What I have:
    COLUMN A
    Dr. P. Schwarts, license #
    Dr. S. L. Jenson, license #


    What I need
    COLUMN B

    Dr. P. Schwarts
    Dr. S. L. Jenson


    What would be the proper formula for this to happen?

    Thank you.
    Last edited by Johfra; 08-14-2015 at 11:38 AM.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Using IF and LEFT formulas to extract uneven information

    =left(a1,find(",",a1)-1)
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    04-25-2013
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Using IF and LEFT formulas to extract uneven information

    Thank you so much Daffodil11! Works great!!!

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Using IF and LEFT formulas to extract uneven information

    Hurray for happy formulas!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract text to left of numer
    By cmb80 in forum Excel General
    Replies: 13
    Last Post: 11-05-2014, 12:46 AM
  2. [SOLVED] extract data from left and right
    By pallet48 in forum Excel General
    Replies: 5
    Last Post: 08-12-2014, 08:38 AM
  3. [SOLVED] Extract all text to the left of a hyphen ???
    By burdo77 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-06-2014, 03:54 AM
  4. [SOLVED] Extract text left and right of character
    By stuartm4h in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2013, 07:32 AM
  5. [SOLVED] Using LEFT function to extract value
    By src16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-04-2013, 09:37 AM
  6. Replies: 2
    Last Post: 08-19-2008, 07:18 AM
  7. Sort a list with uneven row information
    By newexceluser in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2006, 11:35 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1