Results 1 to 16 of 16

Need formula that finds the last ", " in a text string & substitutes it w/ the word "and"

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    Tucson, Arizona
    MS-Off Ver
    XP
    Posts
    43

    Need formula that finds the last ", " in a text string & substitutes it w/ the word "and"

    Hello, I have a text string that might have any number of words in it, all separated by a comma and a space. So one text string might be "dog, cat, boy, girl" and another one might be "dog, cat". I need a formula that will find the last comma and space, and substitute that with the word "and". So instead of the text string stating "dog, cat, boy, girl" it will read "dog, cat, boy and girl".

    Any help would be much appreciated!
    Last edited by danielneedssomehelp; 08-21-2014 at 10:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  2. Replies: 0
    Last Post: 03-21-2014, 09:58 AM
  3. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1