Sometime you will need to extract part of a cell’s contents – e.g. the 1st 3 characters of a part number or the last 4 digits in a Social Security Number.
Excel’s Text Functions (Left, Mid & Right) are “just the ticket” to use.
Watch this short Excel Video Lesson to learn how to do this.
To view all of my Excel Video Training Lessons, I invite you to visit my website –
Nguồn: https://tracyhyde.net/
Xem thêm bài viết: https://tracyhyde.net/category/cong-nghe
Thanks for this, have been having challenges with sorting.
Danny you Rock- Thank you
crap video
Good Video~
That was so helpful… you have no idea !!! I"m facing a challenge though that I can't figure out with Left/middle/right. I need to extract the times from this string "7:48 PM to 8:20 PM (for 32 minutes)
". The problem that I can't use left/middle/right is because the hours of the time, is sometimes 1 digit or 2 digits. E.g. it could be "7:48 PM" or it could be "10:00 PM". So sometimes it's 7 digits and sometimes 8. Any idea what to do ?
i am having issues. instead of it generating the numbers it is giving me a random number
Fantastic Tutorial. Easy to follow.
thanks… it helps a lot
Thanks
Thanks
starts at 1:19
Thank
Thanks Dear "GOOD HELP YOU"
Regard By : Ayaan Ansari
Hello Sir,
You always provide very needful videos. Thanks for this help.
Sir I have a question. Let's suppose we have a paragraph of 800 characters. we need 1 or 2 or 3 complete lines from start of the paragraph but the length of all characters is not more than 230-240 and also not less than 140- 150 characters.
Please solve this problem Sir.
Superb …Great job Allah bless u ….
Explained simply and clearly, thanks
thanks sir….
Explained simply and clearly, thanks!
One step closer to figuring out how to extract data for my lead management. Thank you!
thank you, you've just saved my bacon!
THANK YOU
<3
thank mr now i can continue my studies
VERY GOOD video !!
Thanks for sharing such great informative Video which contains left med & right function in details in single video.
Kind Regards