Use Excel's Left, Mid & Right Functions to extract text

by admin
December 20, 2019
25

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

25 comments on “Use Excel's Left, Mid & Right Functions to extract text”

Felix Adebayo December 20, 2019 at 11:34 am

Thanks for this, have been having challenges with sorting.

Ruben Montenegro December 20, 2019 at 11:34 am

Danny you Rock- Thank you

sahil kwatra December 20, 2019 at 11:34 am

crap video

Pankaj Verma December 20, 2019 at 11:34 am

Good Video~

Marinos H December 20, 2019 at 11:34 am

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 ?

Emeto Judith December 20, 2019 at 11:34 am

i am having issues. instead of it generating the numbers it is giving me a random number

eclecticcyrax202 December 20, 2019 at 11:34 am

Fantastic Tutorial. Easy to follow.

Julis Suryadi December 20, 2019 at 11:34 am

thanks… it helps a lot

Md.Saiful Islam Tuku December 20, 2019 at 11:34 am

Thanks

Md.Saiful Islam Tuku December 20, 2019 at 11:34 am

Thanks

Edmond Dantès December 20, 2019 at 11:34 am

starts at 1:19

MSa ad December 20, 2019 at 11:34 am

Thank

Ayaan Ansari December 20, 2019 at 11:34 am

Thanks Dear "GOOD HELP YOU"
Regard By : Ayaan Ansari

Kamesh Sharma December 20, 2019 at 11:34 am

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.

Muhammed Abdul December 20, 2019 at 11:34 am

Superb …Great job Allah bless u ….

Ksa ksa December 20, 2019 at 11:34 am

Explained simply and clearly, thanks

USMAN SAGGU December 20, 2019 at 11:34 am

thanks sir….

J December 20, 2019 at 11:34 am

Explained simply and clearly, thanks!

Christina Young December 20, 2019 at 11:34 am

One step closer to figuring out how to extract data for my lead management. Thank you!

1881cassandra December 20, 2019 at 11:34 am

thank you, you've just saved my bacon!

Minecraft Surya December 20, 2019 at 11:34 am

THANK YOU

Rocío Ibarra December 20, 2019 at 11:34 am

Andrew .C December 20, 2019 at 11:34 am

thank mr now i can continue my studies

bill sten December 20, 2019 at 11:34 am

VERY GOOD video !!

Sajid Hussain December 20, 2019 at 11:34 am

Thanks for sharing such great informative Video which contains left med & right function in details in single video.
Kind Regards

Use Excel's Left, Mid & Right Functions to extract text - Tracyhyde

25 comments on “Use Excel's Left, Mid & Right Functions to extract text”

Cancel reply