Left, Mid, Right, Len, Find Functions | with Different Digits in Each Item

[@BrayanEspinoza-k5g]

Thank you, I spent the entire weekend on a problem. Your video enabled me to turn in my homework on time, not all heroes wear capes.

[@AlaaNoureldien-m4z]

I hadn't seen the simplest approach to using this function until I saw your video. Thank you so much.

[@SiddheshAdekar]

Awesome video , explained it clearly , Solved me problem instantly, keep it up mate.

[@JavierFlores-r7n]

I used this video to extract this information in a cell [ Disbursement Check #3780: Saturday, June 24, 2023 ]. Into three separate cells. They are [ Disbursement Check #3780 ], [ Saturday ] and [ June 24, 2023 ]. Thank you for this video Joba. And, thank you that this works in older versions of Excel. I was wondering if you can help me take this one step further. I would like to take the information “Saturday, June 24, 2023” and abbreviate it into one cell as [ SAT 06/24/23 ]. This is how I would like all days and dates to look on my Excel sheet. Is there a way to do that using formulas? Bear in mind that I, and a lot of my clients, are running an older Excel version. If you can do a video on this type of thing. That would be great.

[@Giezzel]

Thanks! It was very helpful and I was enabled to extract my data.

[@EmranMohammed-n5c]

Looks difficult but your method is fairly clear. Thanks

[@SabikaFatima-sr5tn]

the above could have been simply separated by using delimited option and further selecting comma and colon and semicolon option.

[@Chloenc1728]

How to solve if doesn’t have “D: “, it’s not working when subtract 3 in this method

[@jaquesadv]

Bom trabalho, mano! ❤🇧🇷

[@SuryaPrakash-jy1mr]

If 'ID:' doesn't exits then how. Can you explain the formulae

[@sopheakkim6715]

Thank you it is very helpful

[@enonamso616]

Nice video, very understandable

[@CLos2381]

What about when the data isn't consistent and uses a combination of , - #, ()?

[@TeaAmaraa]

nice very very useful

[@willsvlog2227]

Bravo

[@Nightmare__-]

Like it

[@leen4573]

[@curtis-xx]

Too much time spent showing what doesn't work....