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://makemoneysecrete.com/
Xem thêm bài viết khác: https://makemoneysecrete.com/tong-hop/
![[CodeGym] Livestream "SOLID – Những nguyên lý sống còn"](https://i.ytimg.com/vi/SoNrd1wYprM/hqdefault.jpg)
![[COMPUTER TIPS] KHẮC PHỤC, SỬA LỖI USB BỊ NHIỄM VIRUS CHỈ HIỆN SHORTCUT 1KB](https://i.ytimg.com/vi/7c-n7o5f-rQ/maxresdefault.jpg)
![[hoccokhi] Hướng dẫn cài đặt Solidworks 2016 thành công 100% | Install Solidworks 2016](https://i.ytimg.com/vi/OAf2qZcB3jA/maxresdefault.jpg)
![[hoccokhi] Hướng dẫn cài đặt Solidworks 2018 THÀNH CÔNG 100% | Install Solidworks 2018](https://i.ytimg.com/vi/4kTc44qQJvo/maxresdefault.jpg)
![[NTH – 1 Click] Sửa lỗi Bad Sector ổ cứng mạnh nhất bằng cách format ở cứng về nguyên gốc xuất xưởng](https://i.ytimg.com/vi/hsPeA5PCIEE/maxresdefault.jpg)
![[Phần mềm quản lý kho WPF – MVVM] – Bài 9: Tạo CSDL SQL Server | HowKteam](https://i.ytimg.com/vi/wSaFowvBIDQ/maxresdefault.jpg)
great video! thanks for making ans sharing 😉
subscribed!
Holy cow Dude, this is increible – adding this to nested substitute is what I needed, !
e.g.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"_AB","_"),"_CD","_"),"_EF","_")
TQ. Nice
Trump lol
nice
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.
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.
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?
How about if I want to give excel two different characters to be substituted by new charters?