Results 1 to 7 of 7

delete "SPACES" at the end of a string or word in a column

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Kerala, India
    MS-Off Ver
    Excel 2013
    Posts
    93

    Thumbs up delete "SPACES" at the end of a string or word in a column

    Hi!

    I have many columns with
    A: ALPHANUMERIC
    B: STRING
    C: WORD , ETC

    All i need is to take off all the <SPACES> at the end of a string or word in a column

    Problem:assuming <SPACE OR SPACES> means " "

    A
    12 DE 2345 F45 68<SPACE>OR <SPACES>
    2324 DKFJ 34 KJK 3KJJK<SPACE>OR <SPACES>

    B
    Mr. Antonio Fernandez<SPACE>OR <SPACES>
    Mrs. Stacy De Maria <SPACE>OR <SPACES>

    C
    New York<SPACE>OR <SPACES>
    Texas<SPACE>OR <SPACES>

    RESULT:

    A
    12 DE 2345 F45 68
    2324 DKFJ 34 KJK 3KJJK

    B
    Mr. Antonio Fernandez
    Mrs. Stacy De Maria

    C
    New York
    Texas

    Thank you
    Appreciate your early reply


    Note: Please refer to the attached file if am not clear in defining my problem
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need formula that finds the last ", " in a text string & substitutes it w/ the word "and"
    By danielneedssomehelp in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-23-2014, 04:06 PM
  2. Delete entire column if word "False" exists
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 02:33 PM
  3. [SOLVED] Delete row if cell in Column N equal "Different" or Column P equals "Blank"
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2012, 08:25 AM
  4. Repost--"Ignore spaces and tabs in word search"
    By pikapika13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2006, 02:55 PM
  5. Replies: 3
    Last Post: 02-15-2006, 01:10 PM

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