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!
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.
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?
If i want mid insted of right, what will be the formula? Is this correct =MID(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-LEN(SUBSTITUE(A2," ","")))
In MS-Excel, How can I Change as follows (automatically)- 1 into 6, 2 into 7, 3 into 8, 4 into 9, 5 into 0, 6 into 1, 7 into 2, 8 into 3, 9 into 4, 0 into 5. As I type 248 in a cell, I would get 793 as result in another cell, As I type 806 in a cell, I would get 351 as result in another cell, As I type 100 in a cell, I would get 655 as result in another cell.
For automatic, a formula is possibly best with a lookup table to know what number to change to what. Then concatenate them. Otherwise, a macro, but you would need to know how to create that macro.
Please never delete this video! It's a pearl.
Thank you 😊 I promise
Your channel has been a life saver again and again. Much more useful than attempting to google random functions.
Great to hear, Nick. Thank you.
That's exactly what I was looking for in order to replace the first occurrence of a string with another one.
Thanks a lot!
Brilliant 👏
Thank you, George.
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!
You're welcome Russ, thank you.
Thank you so much Computergaga for such amazing content.
You're welcome Pratyush. Thank you.
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 Salim.
Great video. Thank you very much; example two was exactly what I needed.
Awesome! Thank you, Oostenwald.
Excellent video depicting example of substitute function. You are showing the usefulness of this formula by demonstrating scenario. thanks a lot.
You are welcome! Thank you for your comments.
Thanks so much for sharing your wealth of knowledge! Great video!
You're welcome Sandy.
Thank you.
You're welcome Vu Hoang.
great video sir, very good use of substitute formula. thanks sir
You're welcome. Thank you, Deepak.
Wonderful ！！👍👍
W video from a W man
😊
Totally totally awesome !!!
Thanks 😊
This was GOOD information! Tighten up the length a little bit.
Thank you, John.
Genius
Thank you, Paul.
thanks so much, really useful!
Great to hear! Thank you, Yaroslav.
Good job 👏🏻
Thank you 😊
Thanx
👍
please show me , how to set next days (find next day cross sheet) in excel?
Sorry Mao, I'm not entirely sure if I understand. If the date was in cell A2. Next day would be =A2+1.
@@Computergaga example : cross sheet 1 and sheet 2 , but we no need holiday . ( i find date , want to run day auto )
To be honest no words for u sir
Words are not enough to compliment u
Your words are enough. Thank you very much Khadim.
@@Computergaga sir how can i be a master in making dashboard?
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?
Thank you, Mike 👍 For your issues, this formula will work - =SUBSTITUTE(A1,"-","-0")
It assumes that your values begin in cell A1.
@@Computergaga Wow, that did the trick! Thank you so much! I'm giving you a 'social distance' handshake!
👊
What is the formula for middle name?
If i want mid insted of right, what will be the formula? Is this correct
=MID(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-LEN(SUBSTITUE(A2," ","")))
@computergaga Wondering if Find and Replace, Text to Columns would have made this simpler...
Can do. I'm not sure what example(s) you're referring too. But they are both underestimated tools, that are worth gold to an Excel user.
Plz give me a formula to extract text from numbers
I have the following video here that splits text and numbers - th-cam.com/video/kKlw6S36TF4/w-d-xo.html
A more complex example may require a macro.
In MS-Excel, How can I Change as follows (automatically)-
1 into 6, 2 into 7, 3 into 8, 4 into 9, 5 into 0, 6 into 1, 7 into 2, 8 into 3, 9 into 4, 0 into 5.
As I type 248 in a cell, I would get 793 as result in another cell,
As I type 806 in a cell, I would get 351 as result in another cell,
As I type 100 in a cell, I would get 655 as result in another cell.
For automatic, a formula is possibly best with a lookup table to know what number to change to what. Then concatenate them.
Otherwise, a macro, but you would need to know how to create that macro.
=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",100)),100))
W=41CM (16.14") L=55CM (21.65") F=8CM (3.15")
Pls remove brackets & Inside Brackets data.....
Final look should be like this....
W=41CM L=55CM F=8CM
I find it hard figuring out where is the word "spices" he mean..until i realize it was spaces
😂