SUBSTITUTE Formula in Excel



SUBSTITUTES formula substitutes existing text with the new specified text in text string

Live Example here:

Free Excel Course –
Paid Online Training –
Best Excel Books:

⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –

Subscribe to get awesome Excel Tips every week:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Nguồn: https://federicobellucci.net/

Xem thêm bài viết khác: https://federicobellucci.net/cong-nghe/


Article Categories:
Công Nghệ

Comments

  • great video! thanks for making ans sharing 😉
    subscribed!

    yamilams July 18, 2020 11:50 am Reply
  • Holy cow Dude, this is increible – adding this to nested substitute is what I needed, !

    e.g.
    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"_AB","_"),"_CD","_"),"_EF","_")

    Ivan G-S July 18, 2020 11:50 am Reply
  • TQ. Nice

    manne sandhya July 18, 2020 11:50 am Reply
  • Trump lol

    LikerOfThings July 18, 2020 11:50 am Reply
  • nice

    A*k star July 18, 2020 11:50 am Reply
  • Can we use wildcard character in Substitute function? for example, I want to remove all characters after the symbol @, hence can we use Old text "@*" New text "". The reason why I need to use Substitute is because of the Instance_num function, because there are multiple @ symbols in a cell.

    Suman Suman July 18, 2020 11:50 am Reply
  • Hello Summit,

    I have faced one problem in relates to this substitute function and example is AssAdeAcs like this now i want only substitute 1st two A A after this the word would look like CssZdeAcs but how i could not find the proper function to replace only two times AA not 3 times A..Could you please help me.

    Samrat Das July 18, 2020 11:50 am Reply
  • I have an excel data sheet in which there are more than 1000 words – Column A with old text and Column B with new text. Company provides me a paragraph where I have to replace old text with new text. Multiple substitutes can’t be used if it exceeds the limit. Is there a way out?

    Titus Dsouza July 18, 2020 11:50 am Reply
  • How about if I want to give excel two different characters to be substituted by new charters?

    Luis Toch July 18, 2020 11:50 am Reply

Leave a Comment

Your email address will not be published. Required fields are marked *