# Excel Video Lesson: Text Functions

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

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:

Any feedback is appreciated.

## 23 thoughts on “Excel Video Lesson: Text Functions”

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

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

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

4. 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?)

5. 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
not jobs in india in this sector without qualification
Help me if u can in ur country…
APPRECIATIVE EFFORT TO SHARE UR EXPERIENCE

6. 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

7. 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!

8. 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!

9. 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.