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.
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.
Awesome video , explained it clearly , Solved me problem instantly, keep it up mate.
I hadn't seen the simplest approach to using this function until I saw your video. Thank you so much.
Thanks! It was very helpful and I was enabled to extract my data.
Looks difficult but your method is fairly clear. Thanks
Bom trabalho, mano! ❤🇧🇷
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.
Thank you it is very helpful
Nice video, very understandable
How to solve if doesn’t have “D: “, it’s not working when subtract 3 in this method
nice very very useful
the above could have been simply separated by using delimited option and further selecting comma and colon and semicolon option.
If 'ID:' doesn't exits then how. Can you explain the formulae
What about when the data isn't consistent and uses a combination of , - #, ()?
Bravo
Like it
Too much time spent showing what doesn't work....