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:
Any feedback is appreciated.
thank u so much so much
This is the easiest way to learn excel by far. Thanks so much and keep up the good work.
Thank you so much.Preparing for a job interview where they will test excel knowledge.
Thank you so much as you showed all those functions that are really useful and you were really good in mentoring via video!
Thanks a lot. This website much is better than going to school.
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?)
Thanks again
Used this tonight to grab info out of a .xml file that i need for work!
Pingback: A Complete Introduction to Excel | MBAx.me
looking at the time of my post as compared to IST i think u r far west…… USA
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
excellent video, great help to the learners, thank you very much
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
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!
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!
These are awesome
-grateful clueless college student
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
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!
Awesome, thanks a lot for taking the time to put the video together!
Just wanted to thank you, it will help me out a ton in school. I look forward to more!
THANK YOU!