Using LEFT RIGHT & MID Functions in Excel

GOOD CONTENT

How would I do the mid function if I have different lengths of characters? Say June, September and March

very helpfull !

How to write a formula where it excludes the parenthesis on the left?

this data manipulation requires uniform data

Hi Sir,
NEFT-HSBCN23212775696-NATIONAL INSURANCE CO LTD.
How can I find out HSBCN23212775696 from this, which formula will I use?
Please help.

Thank you for this! Appreciate it!

Thank you

Golden!

Would you please give the practice file. The download link you already share is not working currently.
Thank you

Only in this video that I understand that formula

Why not use find function and make this formula dynamic rather than counting the position of the desired text.

so good

You did Everything manually..instead of counting, can you show find and len function using mid function

The Video was Useful ❤️😊

This was so helpful.
Thanks so much I appreciate it.

great example, and clear explanation. Thank you sir.

Thank you!! This is so helpful

Thanks for the video, great and easy to understand

excellent can clearly understand

Thanks bro it is the easies and fastest way to split the text what ever that is and keep it up

good job Sir

আমাদের ইন্ডিয়াতে এতো straightforward data আসে না ভাই

I can't download this file. Can I get the real file for practice?

Thanks for sharing information

Thanks you very much for the video. Still remains a question. Anyone knows how to use the left function for a number, without taking the zero as a number. For instance, LEFT(0,55) gives 0 as output, while I want to ignore the 0, and only get the 5. Anyone can help me?

Sir please say formula (india private limited-12345) how to split company name only like india private limited

Easy and working.

Thank u for making such useful n easy to understand videos ,i have recently started watching ur videos n i just love ur explanation pls upload more videos n can u pks also make ms power bi videos

So helpful ..Thank you sir...

Thank you！It‘s so helpful

These helpful

This is great, however the issue I have is that there is a "." following each month, IE June., I don't want the period to show up. How would you remove that?

thanks

Thanks

thanks

What if we want to retrieve the Date Number from the given date?

Great example and explanation! thank you!

best way is to do Alt+A+E then extract from , or space.......... so easy...

Do nambri bgerat video

Thanks

How you extract the State? Since it's different lengths

thanks!

Your presentation was on point. Great job!!! Thanks

it was useful thanks!

if there is any blank cell in Column D,how it will work in Auto fill in column F???

really appreciate it, this video helps me to solve my issue. thanks

It was very helpful thanks

Thnks alot 🥰🥰

Fantastic