Results 1 to 7 of 7

Thread: Find the First or Last So Many Words in a Text String

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-19-2012, 03:22 PM #2
    snb
    snb is offline
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    Did you consider; to return the first 4 words:

    PHP Code:
    =LEFT(A1;FIND("@";SUBSTITUTE(A1;" ";"@";4))) 
    The N in your formula is 4 in mine (as an example)

    PHP Code:
    =LEFT(A1;FIND("@";SUBSTITUTE(A1;" ";"@";N))) 
    The last N words:

    PHP Code:
    =MID(TRIM(A1);FIND("@";SUBSTITUTE(TRIM(A1);" ";"@";1+LEN(A1)-LEN(SUBSTITUTE(TRIM(A1);" ";""))-3));LEN(A1)) 
    Last edited by snb; 06-19-2012 at 06:07 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Get Field from Delimited Text String
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 5
    Last Post: 07-25-2025, 08:35 AM
  2. Extracting Custom Pattern Consisting of Numbers & Text From Alphanumeric String
    By larkspur in forum Excel Help
    Replies: 14
    Last Post: 05-25-2013, 06:55 AM
  3. Extract Certain Characters From A Text String
    By bobkap in forum Excel Help
    Replies: 5
    Last Post: 05-24-2013, 06:25 AM
  4. Find Color in the string using formula.
    By LalitPandey87 in forum Excel Help
    Replies: 4
    Last Post: 07-10-2012, 09:16 PM
  5. Count the occurrences of text, characters, or words in Excel
    By littleiitin in forum Excel Help
    Replies: 6
    Last Post: 09-26-2011, 07:39 AM

Tags for this Thread

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