Advanced Excel Tutorial: Extracting Dates, Amounts, and Descriptions (Text Formulas)

[@PerkyStar]

Hi! I would like to know for example there's currency before the number (amount) and I want the amount not included in the description? how can I do with the formula? Badly need help! Thanks.

[@HectorGarciaCPA]

Ask ChatGPT :)

[@ddifferent21]

Awesome trick with the spaces !

[@HectorGarciaCPA]

thanks

[@tanayjain9416]

Thanks

[@HectorGarciaCPA]

You welcome

[@qasimjan5258]

Why don't you use power query for this purpose hector.

[@HectorGarciaCPA]

simple answer, I dont know how to use it..

[@HectorGarciaCPA]

But i have another video coming for FlashFill

[@qasimjan5258]

ua-cam.com/play/PLHYaVuyjhcqyYD7qss7lsFVBLf8B_zZrx.html