+ Reply to Thread
Results 1 to 6 of 6

Remove text between characters

  1. #1
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Remove text between characters

    I import a daily report and I need to remove part of a string. As an example the data I receive "42642_19_8" but I need to remove "_19" so I end up with "42642_8". If possible I would like to overwrite what is in the column but this could be an additional column if necessary. At present I am writing a formula to achieve this. Cheers

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Remove text between characters

    In order to do as you have ask we need to set parameters for the removal of text. Since you only gave one example, I will assume that you need to remove the middle characters between two underscores. I will also assume column A. Any poor assumptions will need to be corrected by you.

    Please Login or Register  to view this content.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Remove text between characters

    Deleted post
    Last edited by AlKey; 02-13-2015 at 11:30 AM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Remove text between characters

    @Alkey

    CTRL + H opens the replace tool
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Remove text between characters

    Quote Originally Posted by oeldere View Post
    @Alkey

    CTRL + H opens the replace tool
    So is CTRL+F and it is more convenient because F is located closer to CTRL than H

  6. #6
    Forum Contributor
    Join Date
    11-28-2005
    Location
    Dover, England
    Posts
    172

    Re: Remove text between characters

    Thanks to both of you. Al I'm afraid I had already tried your solution but this removes both sets of numbers not just the middle. Stnkynts your solution worked a treat.

+ 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 Characters from Text..?
    By SubPar in forum Excel General
    Replies: 2
    Last Post: 11-19-2012, 05:44 PM
  2. Remove Characters to the Right of text
    By kmlloyd in forum Excel General
    Replies: 2
    Last Post: 11-24-2011, 03:16 PM
  3. remove characters from a text under a condition
    By elaine216@gmail.com in forum Excel General
    Replies: 5
    Last Post: 06-05-2006, 12:30 PM
  4. [SOLVED] want to remove all text characters equal to one character in length from text string
    By tinalwalton@yahoo.co.uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2005, 05:06 PM
  5. [SOLVED] want to remove all text characters equal to one character in length from text string
    By tinalwalton@yahoo.co.uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2005, 08:10 PM

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