Excel Video Lesson: Text Functions

This video tutorial is a demonstration of the Experience Level 1 Text functions.

Make sure to download the newest version of the Master Workbook that I updated earlier today to follow along.

The functions covered in this lesson are:

CONCATENATE — EXACT — FIND — LEFT — LEN — LOWER — MID — PROPER
REPLACE — RIGHT — SEARCH — TEXT — TRIM — UPPER

Extract of Level 1 – Text Functions from the Master Workbook:

Next video lesson is Logical Functions and Formulas.

Any feedback is appreciated.

This entry was posted in Function-Related Lessons and tagged , , , , , , , , . Bookmark the permalink.

43 Responses to Excel Video Lesson: Text Functions

  1. Bryan says:

    Thanks for the lesson i feel my time has been use profitably

  2. Anonymous says:

    Thank you

  3. Anonymous says:

    Thank you!!These videos are excellent!

  4. Sam says:

    thanks a lot last one was too good

  5. sachin says:

    Superb Ben- People like you always encourage free and excellent education for all. Its been fun watching and learning through your videos.
    Great and keep going…!!!

  6. Gerard says:

    Hey Ben how can I paste in the stuff that you did at the start of the video. I can’t figure out exactly how to do it easily. Thank you

  7. Harris Tsaravas says:

    When you type a function in Excel for Mac, pressing Tab doesn’t fill in automatically the function but changes cell. Any tip ? Thanks

  8. Joy says:

    I was looking for something to help expand my knowledge of excel at the behest of my employer. I have found the videos invaluable and I refer to them almost daily – either to learn something new or to review and experiment with my own data. Love the videos.

  9. Manish says:

    Good Videos 🙂

  10. Anonymous says:

    Thank you, I know I’m no master but this has helped

  11. Anonymous says:

    thx so much, this is such a treasure and indeed the best Excel tutorials.

  12. Anonymous says:

    Hi,
    Ben,
    I sorry but the videos do teach any thing they just run out. for example I started with lesson two and the time for video was 14.36 mins but the video shut down within just 1;00 min of time teaching me nothing about excel functions. And not one but all the videos work the same way.

  13. Gilbert says:

    I love the way the lesson is structured, so that it is easily understood. Thank you so much!

  14. Felicia Holmes says:

    This was great, thank you!

  15. arun gadia says:

    how to correct a circular reference

  16. Anonymous says:

    thank u so much so much

  17. shermaine says:

    This is the easiest way to learn excel by far. Thanks so much and keep up the good work.

  18. edina says:

    Thank you so much.Preparing for a job interview where they will test excel knowledge.

  19. Lindy says:

    Thank you so much as you showed all those functions that are really useful and you were really good in mentoring via video!

  20. Anonymous says:

    Thanks a lot. This website much is better than going to school.

  21. jeff says:

    I learned excel 20 yrs ago & have only used it for basic stuff. Excel 2010 came along & I now realize how far behind I am. I need to become more proficient for my job & your time & effort are a tremendous help. Well organized & easy to follow. Thank you! (Do you take on contract projects?)

  22. danny says:

    Thanks again

  23. Pingback: A Complete Introduction to Excel | MBAx.me

  24. Nishant says:

    looking at the time of my post as compared to IST i think u r far west…… USA

  25. Nishant says:

    right now i m jobless….
    my qualities:
    1 very very very good in logical reasoning
    2 can read any type of stock market… be it equity currency or commodity or even index related
    dont have requisite qualification
    only a graduate B Com
    not jobs in india in this sector without qualification
    Help me if u can in ur country…
    APPRECIATIVE EFFORT TO SHARE UR EXPERIENCE

  26. Anonymous says:

    excellent video, great help to the learners, thank you very much

  27. Ali says:

    These are helpful, thanks. I personally am an interactive learner and the past couple I have clicked on just basically have you watch so I found those less useful.

    • Hey Ali,

      I struggled with this myself. For the function videos, I had to do them a bit less interactive in order to keep the overall video length managable.

      These examples still exist in the Master Workbook though, and you can certainly follow along / play with the formulas as I go through them in the video…

      Hope that helps, either way I appreciate the feedback 🙂

      Cheers,

      Ben

  28. Rick says:

    This is probably a really dumb question, but in these examples you’re always referencing a cell that’s populated with data and never actually changing the data in the original cell. Is there a way to use the UPPER function to convert a column to all uppercase if all the data is already sitting in front of you rather than just copy it to a new cell with proper formatting?

    • One option would be to run the UPPERCASE formula in a separate column on all the cells (by putting, for example, =UPPERCASE(A1) in cell B1 and then clicking the fill handle to drag it down through all the cells. Then you can copy that column and paste -> values over the original text.

      Hope that helps!

  29. Elena says:

    Lifesaver, really. I’ve been watching your videos for 2 days straight now and I’m amazed at how well they are done and how exhaustive they are! Many thanks all the way from Italy!

  30. Anonymous says:

    These are awesome
    -grateful clueless college student

  31. Hey Joey,

    Thanks for the feedback, I added in some explanations of which formulas I’m covering in the video and a snapshot from the Excel spreadsheet.

    Hope to be uploading another couple videos later tonight or tomorrow.

    Thanks!

    – Ben

  32. joey says:

    I think it would be nice if you could put a little summary of the functions used in the post. Anyway nice work, keep going!

  33. Rado says:

    Awesome, thanks a lot for taking the time to put the video together!

  34. Brian says:

    Just wanted to thank you, it will help me out a ton in school. I look forward to more!

  35. redditor says:

    THANK YOU!

Leave a Reply