Results 1 to 7 of 7

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

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    Well, I never suggested anything 'better'; I prefer talking in 'alternatives'. But still I think my formula hasn't the 99 words limitation your suggestion has. How to assess that (lack) of limitation is a question of personal preference in my opinion.

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by snb View Post
    But still I think my formula hasn't the 99 words limitation your suggestion has.
    That is a strong point in favor of your formula, no doubt (and many will probably prefer it for that reason), but, as I mentioned, I still kind of like the symmetry of contruction between the two formulas I posted (just swap out RIGHT for LEFT or vice-versa depending on which end you want to count from).

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. 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. Replies: 6
    Last Post: 09-26-2011, 07:39 AM

Tags for this Thread

Posting Permissions

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