In this video we look at 3 advanced examples of the SUBSTITUTE function of Excel.
This brilliant Excel formula helps us to manipulate and evaluate text strings in Excel.
There are many reasons to love the SUBSTITUTE function. This video narrows it down to 3 advanced examples.
Want to see more advanced tricks?
Check out our online course –
**FREE Instant download – 27 Awesome Excel Hacks –
Find more great free tutorials at;
Connect with us!
LinkedIn ►
Facebook ►
Twitter ►
Nguồn: https://makemoneysecrete.com/
Xem thêm bài viết khác: https://makemoneysecrete.com/tong-hop/
The way you break down and explain each and every step is amazing! The issue I am currently having is perhaps related to, but different than the 3 examples you showed. I want to add zeros to a text string of characters. The 6 numerical characters are broken into 3 pairs which are then separated by 2 hyphens. For example: 01-01-22.
I wish to insert a zero to the right of each hyphen. Example: 01-001-022. I have tried various methods but to no avail. Any suggestions?
Useless video😵😵
please show me , how to set next days (find next day cross sheet) in excel?
To be honest no words for u sir
Words are not enough to compliment u
Thank you so much Computergaga for such amazing content.
I find it hard figuring out where is the word "spices" he mean..until i realize it was spaces
Amazing. Computergaga is one Word, but it means really a lot to everyone who wants to be good at Excel. Your Excel knowledge is excellent Alan. Thanks indeed.
Thank you.
Thanks so much for sharing your wealth of knowledge! Great video!
Love it. Just a few days ago I was extracting the file names from full paths and wrote some convoluted VBA to achieve it. This is much more clean and concise. Thanks!