Results 1 to 8 of 8

Replacing Words in Respective Rows

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy Replacing Words in Respective Rows

    Hi, I am trying to replace each occurence of these items:

    {city_name}, {state_name}, {state_abbreviation}

    with its corresponding city, state and state abbreviation in these columns (the first three):

    city_name state_name state_abreviation

    So, for example, column D, Row 2 would read: "Atlanta Widgets - See Widgets in Atlanta, Georgia"

    All cities and states need to be in title case except the slug needs to be in lowercase.

    The attached file is only a sample of the thousands of rows.

    I hope this is clear. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1