I have been trying to figured out how to pull the account number only from the chart of accounts number string for 2 days and this did it in 2 minutes!!!! Thank You so much for your help!!!!
Great tutorial, I was able to get the same results following along. But I'm struggling at translating into words part I don't understand why we put the mid function twice at the left formula.
HI, i need to extract text between two words and i am using below formula but its not working can you help ? i am trying to find all the words between KTE AND FUT, IFERROR(MID(A9,SEARCH(“KTE”,A9)+LEN(“KTE”),SEARCH(“FUT”,A9)-SEARCH(“KTE”,A9)-LEN(“KTE”)),””)
I love the method used to explain it by breaking down each step, super easy to understand that way. Thank you
the best video I found at breaking apart each function so I could understand it...thank you so much
Great way of explaining the long formula, separating it in 3 and putting it together. Thank you!
I have been trying to figured out how to pull the account number only from the chart of accounts number string for 2 days and this did it in 2 minutes!!!! Thank You so much for your help!!!!
Excellent tutorial. A great formula built little by little. Thank you Chester!
Thank you for this video! Amazing!
Thank you for this video. It helped me through a project
Hi @Chester thank you for this! You are a legend!
loved it, sir. please make about combination formula excel video............
wow. This is a great video and solved my current requirement. Big thanks!
Great tutorial, I was able to get the same results following along. But I'm struggling at translating into words part I don't understand why we put the mid function twice at the left formula.
Amazing 👏, all methods are gr8 will depend on which situation
Thanks a lot 😊
Thanks a lot, it's really very helpful.
Thank you so much for this tutorial 😊
great explanation thank you
Life saver, thank you!!
HI, i need to extract text between two words and i am using below formula but its not working can you help ? i am trying to find all the words between KTE AND FUT, IFERROR(MID(A9,SEARCH(“KTE”,A9)+LEN(“KTE”),SEARCH(“FUT”,A9)-SEARCH(“KTE”,A9)-LEN(“KTE”)),””)
Thanks!
you're Aaaaaaaaaawesome ❤🔥❤🔥💯
Thankyou so much😊
Thank you so much!