Comments on: How to delete text before or after a certain character in Excel

In the recent couple of articles, we've looked at different ways to remove characters from strings in Excel. Today, we'll investigate one more use case - how to delete everything before or after a specific character. Continue reading

Comments page 2. Total comments: 56

  1. Great :)

  2. Hi, I want to remove the line break before all lowercase characters. Please let me know if there have any solutions

    example -
    Impactful
    speeches
    • Staying

    Output-
    Impactful speeches
    • Staying

    Regards & Thanks,

    1. Hello!
      To remove line break before specific character try this formula

      =IF(AND(CODE(MID(B2,SEARCH(CHAR(10),B2)+1,1)) > 96, CODE(MID(B2,SEARCH(CHAR(10),B2)+1,1)) < 123), REPLACE(B2,SEARCH(CHAR(10),B2),1," "),B2)

      I hope my advice will help you solve your task.

  3. Hello Sir,

    I required VB function code for only removal XXXX.XXXMTQ XXX.XXXFTQ.

    Example - as per showing

    ASLS2O11252 1 BULK 20150.000KGS 25.000CBM
    SN# 15577 44423.146MTQ 882.867FTQ

    Need output - without removal SN Number and MTQ/FTQ number will be random number.

    ASLS2O11252 1 BULK 20950.000KGS 25.000CBM
    SN# 15577

  4. Hello team,
    Can you help me to change PROD-001 to Product 1, I have been using multiple separate formula so it's kind of ugly.
    I would be appreciated a lot. Thank you

  5. Thanks a lot Sir,
    I applied this formula it is working :-=LEFT(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999))-1)&" "&MID(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999)),50)

    but only one string no changed i.e.65Hanjarwal
    It is still 65Hanjarwal
    can you help me I need like this result : 65 Hanjarwal

  6. Hello dear Team,
    I need your help, that I want make spaces between the text and number below
    strings i tried myself but not get success.

    text string
    65Hanjarwal
    C2160feetRoad
    C19JaffriaColony
    G14sunderIndustrialstate
    CANAL BANK2
    C18AshyanaHScty
    222-LT-LTS-M15FZR
    C41OPP240B
    C2 84981C12
    C13OPP3402C2

    Thanks a lot

    1. Hi!
      To insert a space before the first digit you can use this formula:

      =LEFT(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999))-1)&" "&MID(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999)),50)

  7. This saved me so much time and energy. Super easy, way more efficient than manually updating 10690 columns of data. Thank you!

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)