+ Reply to Thread
Results 1 to 2 of 2

Extract text from string after , before a space

  1. #1
    Forum Contributor
    Join Date
    12-03-2009
    Location
    Providence RI
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    260

    Extract text from string after , before a space

    OK, I don't know why I am having trouble with this.... I know what I want excel to do and what I was thinking of to get it to work. But I am having trouble getting it to do so. Currently I have =MID(N8,FIND(",",N8)+2,(LEN(N8)-FIND(",",N8))) which is simple enough.

    My problem is extracting only up until the space after the comma. I was trying to use MID/FIND with the result of the above formula which creates a rather large formula, but it keeps throwing a #VALUE at me and I can't figure out the best way to do this.
    Last edited by Dulanic; 05-24-2010 at 08:21 AM. Reason: solved

  2. #2
    Forum Contributor
    Join Date
    12-03-2009
    Location
    Providence RI
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    260

    Re: Extract text from string after , before a space

    Figured it out, I had some without a space and that happened to be one I was trying it on. I added a IFERROR.

    =IFERROR(LEFT(MID(N8,FIND(",",N8)+2,(LEN(N8)-FIND(",",N8))),FIND(" ",MID(N8,FIND(",",N8)+2,(LEN(N8)-FIND(",",N8))))),MID(N8,FIND(",",N8)+2,(LEN(N8)-FIND(",",N8))))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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