+ Reply to Thread
Results 1 to 4 of 4

Mass deletion of the space character next to the selected character

  1. #1
    Registered User
    Join Date
    11-11-2018
    Location
    london
    MS-Off Ver
    2018
    Posts
    2

    Mass deletion of the space character next to the selected character

    I would like the space characters to disappear to the left of the "|" and i would like to delete "{***}"

    for example, I have such a text in the worksheet. The problem is that it's 5000 lines.

    dlga_start:blocked_agent |This person seems busy. Maybe I should move on...{***}

    the text in the rows may have a different number of columns compared to the others.

    should look like: dlga_start:blocked_agent|This person seems busy. Maybe I should move on...

    how to solve this problem the easiest way?
    (with the exception of manual correction)
    Last edited by foxal; 11-11-2018 at 10:54 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Mass deletion of the space character next to the selected character

    Hi, welcome to the forum

    Maybe try this approach? Do it separately for each "replace"
    highlight your range
    press CTRL H (find/replace)
    Find *| (I copied this from your actual data - *space*|)
    Replace | (I used the same "copy", and removed the leading space)

    Repeat this, but use
    Find ...{***}
    Replace ...
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-11-2018
    Location
    london
    MS-Off Ver
    2018
    Posts
    2

    Re: Mass deletion of the space character next to the selected character

    thank you very much

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Mass deletion of the space character next to the selected character

    Happy to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to remove space after a particular character
    By sugaprasad in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-20-2015, 05:02 AM
  2. Find 1st character after a space
    By milo1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2013, 09:07 AM
  3. [SOLVED] Insert two space after character
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-29-2012, 10:46 AM
  4. [SOLVED] Need to add space after every 4th Character
    By yus786 in forum Excel General
    Replies: 10
    Last Post: 04-04-2012, 06:08 AM
  5. Unknown Character Creation/Deletion
    By jomili in forum Excel General
    Replies: 2
    Last Post: 12-30-2010, 11:08 AM
  6. [SOLVED] How do I replace a BEL Character of 7 with a space
    By KBear in forum Excel General
    Replies: 1
    Last Post: 06-06-2006, 11:00 AM
  7. [SOLVED] How to count character and space?
    By Rocky Lam in forum Excel General
    Replies: 4
    Last Post: 01-08-2005, 09:07 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