6 hours 3 minutes
in this lesson, you will learn how to use basic text formulas and functions to pin to manipulate text that has been entered in Excel.
see it to the
group off names first name, last name.
The civilian entered in cells and they have some typing errors.
I'm not typing in in the meaning that
some of the letter has been time correctly. But the case of the letters hasn't bean typed properly
and we want income. See tohave name,
first name and last name separated by space we have seen before.
Um and then, uh
everything should be done properly.
And for that, we're going to use a text function called proper
and let's go to formulas
and let's go to text ones
and just die proper
and the proper functions does. Very simple thing. Takes the text. You're referring to a CZ. An argument
makes the first letter always.
uppercase and the rest of the letters lower case. So we can say a proper out of this
and then we can see
and we can put
and then again and
report. Press this and get it, Mike White. Now, if we
we got everything. Perfect.
We double click here.
Just to make this comb is why does need it for all the
these names fit in without crossing into next gone
and let me show you the other way to do it.
And I'm going to show you the other way as well. So the third way.
So we can also do
I want off.
And then this
and then we copy this
and look, we got the same results.
So this is one very nice thing about functions in
Excel is that the arguments of these functions don't necessarily have to be a reference to a single cell. It can be for your formula by itself.
So I put the proper
the formula within as an argument and we got the string. So Excell first calculates
the value of the formula and then applies function to whatever has become result of that formula. Now there is 1/3 way to do it.
We can use
Ah, the another function so we can see
we can use another function which is
this close brackets once, twice months, we get the black one. You know that it is the last one,
and you just press enter.
Let's do the copy
and we get the same result. So function can Captain eight
basically puts together strings,
which are arguments of this function. And there can be quite a lot of these arguments so that it's not limited to 12 or three.
And it does the same thing, absolutely the same thing as adding strings together or texts together with end
But what I wanted to show you this is the is that the argument off the function can be another function, and you can have multiple levels off that I think up to six,
sometimes even more so you can have a function within function within function and so on.
So this is how it works. We achieve the same thing in a three different ways,
and you can say that each one of these is better than the other. It's they just work in the same way.
So this is how human it'll manipulate text in excel.
Now there are much more advanced ways to manipulate text. But at this level, off course, I will stick to what you have seen now. And I'm not going to refer much more about formulas regarding text because this is something that is usually done on much more advanced level off
usage of excel.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered