@@ExcelOlympics Sometimes.. usually if a one time conversion and I can be pretty sure the AI gets it right. Generally, I'd say I use a mix of formulas, Flash Fill and Power Query, depending on the circumstances. Cheers!!
Hi Irene. thank you for the kind words! I am a huge Beatles fan and that0s why there are so many beatles references in my videos. Are you a Beatles fan?
@@ExcelOlympics Yes, I am a BIG Beatles fan from way back - they were such a huge influence in my growing up years - it was always such a thrill when the newest album came out! Played them endlessly. There’s a George Harrison 10 minute interview I recently found that is superb. He was so cool. Let me know if you are interested and I’ll post the RUclips title to this thread. Keep your teaching videos coming - they are helping me to keep up on my data analysis skills, for sure!✌️
I would mostly agree with your comment although I think it's more about the amount of data than the environment itself. But a dynamic formula would take precedent every time (for me at least).
Great tutorial and advice! Thanks and thumbs up!!
Thanks Wayne. Do you use Flash Fill a lot?
@@ExcelOlympics Sometimes.. usually if a one time conversion and I can be pretty sure the AI gets it right. Generally, I'd say I use a mix of formulas, Flash Fill and Power Query, depending on the circumstances. Cheers!!
Same here 😀
Enjoying your channel! FYI - I particularly like the Beatles references😀. I use the flash fill all the time, it is a huge time saver!
Hi Irene. thank you for the kind words! I am a huge Beatles fan and that0s why there are so many beatles references in my videos. Are you a Beatles fan?
@@ExcelOlympics Yes, I am a BIG Beatles fan from way back - they were such a huge influence in my growing up years - it was always such a thrill when the newest album came out! Played them endlessly. There’s a George Harrison 10 minute interview I recently found that is superb. He was so cool. Let me know if you are interested and I’ll post the RUclips title to this thread. Keep your teaching videos coming - they are helping me to keep up on my data analysis skills, for sure!✌️
Will do on the teaching videos and I sure would love to know the title of the interview. Thanks in advance Irene.
@@ExcelOlympics The title is: ‘Will People Ever See It? George Harrison On The True Experience.’ Enjoy!
Can't trust when you work in professional environments with large amount of data.
Better to use some old fashioned formulas to split or joint text.
I would mostly agree with your comment although I think it's more about the amount of data than the environment itself. But a dynamic formula would take precedent every time (for me at least).