this is such a huge help. what i did at first was to extract by using find and then from that, extract using left. Didnt know, i can combine the two. so thank you!
Great. Its works. If i have a list of large data in which some cell data include - or some does not. How we can get exact no?? For example. 1) 00000sl1902-038-999 2) u2decls025 My formula skiping 2 result error
Hi what formula should I use if I have Spencer, Caroline A in cell A1 and I want to get Tanwar, Vaishali in cell B1. I basically want to remove the middle name.
Hello I just caught your video on the left find formula. I have been trying to figure out how to do this. I wrote the formula just like you have it and a error pop up came up asking if I was trying to write a formula. This is the trouo8ble I have been having with this formula. Any help fixing this problem would be greatly appreciated. Thank you Matt
The link for the practice spreadsheet is in the video's description. I'll include it here too: bit.ly/EXCELleftfind You can just copy that link, and paste it into your browser, and go to the link, and the spreadsheet should automatically download to your computer.
Can you please tell us where a beginner should start to learn step by step computer skills? Great videos, it’s very much appreciated.
this is such a huge help. what i did at first was to extract by using find and then from that, extract using left. Didnt know, i can combine the two. so thank you!
combine formulas in excell is vital, thank for your guidance
Congratulations for 1 million subscribers 🌹♥️👏🥰
Very helpful and clearly described, thanks!
U have explained very beautifully, thanks a lot.
Your videos are immensely helpful, thanks a lot
Brillant formula. Thanks for the video
Love the band choices! Blaqk Audio, Depeche Mode, Erasure are favorites ... I will check out Covenant. PS -- Thanks for the Excel lesson! :)
Great. Its works.
If i have a list of large data in which some cell data include - or some does not. How we can get exact no??
For example.
1) 00000sl1902-038-999
2) u2decls025
My formula skiping 2 result error
You did great as always! Thank you so much!
Nice, simple and very helpfull
Excel has a built-in formula the works as Left(find).
It's called "textbefore"
I was wondering how to stack two words in a cell?Yes newby here and i love your channel
Try using the "Wrap Text" feature. That's one way to do it. Thanks for your kind words.
Great as usual 🛸✔
Great video
Thank you
Hi what formula should I use if I have Spencer, Caroline A in cell A1 and I want to get Tanwar, Vaishali in cell B1. I basically want to remove the middle name.
Hi very useful video! It's not working for Right function? Can you help please? Thanks
Hola ! Can we use SEARCH Fx instead ?
Hello
I just caught your video on the left find formula. I have been trying to figure out how to do this. I wrote the formula just like you have it and a error pop up came up asking if I was trying to write a formula. This is the trouo8ble I have been having with this formula. Any help fixing this problem would be greatly appreciated.
Thank you
Matt
try ; instead of ,
Can I have a download from the complete working sheet, because this won't working in the Dutch translation ...
Where is the spreadsheet? Can we download it?
The link for the practice spreadsheet is in the video's description. I'll include it here too: bit.ly/EXCELleftfind You can just copy that link, and paste it into your browser, and go to the link, and the spreadsheet should automatically download to your computer.
What about right
Should have shown how to remove it from the A2 cell then leaving only the song name.
how old,