Results 1 to 8 of 8

can't remove commas at the end of a string

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-21-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    502

    can't remove commas at the end of a string

    In an Excel column I have strings of text. Some end with a comma. Others end without a comma. I want to remove all the commas at the end of the strings. How do I do that? Below is an example.

    Column A
    large building
    small building,
    skyscraper,
    tall, house
    house boat
    cabin

    Note: the comma after "tall" I don't want to remove.
    Last edited by dschmitt; 02-26-2013 at 03:45 AM.

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