8 hours 33 minutes
ext functions with the function England,
and it is a simple function that returns the land of next drink.
So just to show you height works,
just tape course
and you get nine because this one has nine characters. And if you expand the function, too,
you see that the club has
Weathers, and this is why the limit is four.
Now. This function by itself doesn't have much of a use, but you'll very soon see how
it is very useful, combined with other functions.
is lower, and it's also very simple function that converts all letters in a tank string to lower case. Now, there are very few situations where you would just need to do that.
But in some situations
Ah, you would, uh, probably,
er, use that in
projection with the other functions.
For example, if you want to make sure that
in ah sentence only the first word has the first capital letter and the remainder off
the text is our case.
this is it,
this is it.
And now we can to run very useful function, which is called mid
and it returns the strength, the string with the given length and from given position off original strength. So if you have string that says 12345 and then we use mid function and start with number three and then we number four you will get a string with just three and four
to see how it functions is that we have here already pretty different formula. And I'm going to go through with it because it's a rather complex formula and you have to understand what it does.
first argument is the text string which were working on which is a one,
and then we have ah, to find
and we want to separate
second word in this three word strength.
So we're looking at
for his position and the first position. And now there is a great use for the find
we say find. And then we're looking for the space
in a one
and when you get that number, we add one more, because here first
and space. But space is in position six
and we want to start with next position in the string, which is second, which s in second and it's number seven. So we add one
and then we want to find the length and D Lent
is again find.
And then we again. We're looking for a space in a one.
we want to start looking at the position which is the position off first space plus two and then subtract from it the position off the first base
and then minus one. So this looks probably very complicated at this point,
but this is how it works. So we're finding the position off the second space
on. And we do that by looking at the
space in this
1st 2nd 3rd text string,
but not from the beginning, but from the position, which is one position Maur
are after the position of first base.
we subtract from that
the position off the first base. And then again we subtract one more
and we get second. And to make sure that this is without any spaces,
we're going to copy this as well you.
And when you look at here, we don't have any spaces before, and no spaces after word second.
So this is how mid works
recommended for you to look at this formula studied and tried to find Why is it
done like that?
So the next function is number of value
and when it clears tex to number in any format that was written into why is it important? So, for example,
we have ah, countries
decimal separator is not
point. It's Kama
and 1000 separator is point, not comma.
number well, you
and then we're going to
look a TTE the text which is going to be
converted into number
and then we're going to type in the decimal separator
which in this case is comma.
And then we're going to type in the thousands separator which in this case, it's worry is
and we're going to close it
and we're going to get the number in the usual way
typing it. Actually, this is just the number and we had formulated this cell tohave to decimal places and to use 1000 separators which in this case, is comma.
Next function is proper
and it basically converts names to proper case. So
the result is always going to be the first letter is upper case in the others are lower case. It doesn't matter. How many words do we have in
the cell or the text? We're applying the proper function too.
just to see how it
presumably somebody has entered,
uh, the name
You're just going toe
corrected with proper function.
It is important to remember that we cannot use this correct sentences because it will put the uppercase letter at the beginning of every word.
And this is not what you want to do with
Now we're going to look at the function replace
is basically replaces all text with new one within strength
except the old text.
You have to enter
the starting position in which you're doing replacement
number of characters you're replacing and new text, which you're using to replace it with.
So this is not like replace. You have in the, for example, Microsoft word
where it will find
the text and replace it. Now you have to find it yourself.
And to explain how to do it
is going to
be a little bit more complicated. But
So the old text
and we want to replace thes two peas
with one p.
So we're going to use the find function
and we're looking for double B
this text here.
this is our starting position.
And the length is, too, because we're replacing two peas
and the new text is going to be one
and we're to close it
and we get the proper spelling. Of course. How did we get to it?
It's a different story, but let's say that we know that this kind of typing error has been made and we want to do it.
So next function is right
and we're going to
so right function is basically one that returns specified number of characters from the end of text drink. So if we have a B, c, D E f and we say right
and we put that text string and then for a number of characters, we put,
too, and it was a B. C. D. We will get the Andy,
let's get back to do the example, and we have the same example like we had in the mid.
But now we want to separate the last word in the
so we're going to type right
and then it gets complicated from here. So this is the next year
and then we're going to
the number of characters. So the number of Carter is length off
the position off second space
and position off second space. We'll find, we find.
And then we're going to look a TTE space
And then it's going to be
again in a
one. So we're looking at the first position
and that position
to the position we're going toe. Add
in close one, too,
and we get third. This is what we were looking for.
So again, like we admit, it's a complicated function.
But if you put your mind to it, if you're right, it on the paper before you type it in or you type it in and do some try whenever you will understand how to do it. Of course,
if you're you can always use this example and copy, paste it. It's clear
way to do it simply
if you're looking for the same thing
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand