8 hours 33 minutes
Okay, This is the last part of ex functions. Listen,
And the next function I'm going to talk about this search.
It's pretty much the same function as find Onley. This one is not case sensitive, so it will find a certain string within another string and it will give a cz Ah return the position of that string with that string.
Also, you can define from which character in the search string are you starting from the search. And, uh
So just to see
how it looks,
we can do it like this. So we're going to look for to Capitol Peas in this text
here that has lower case bees
and we're going to start from position one.
here it is. We get
as a return the number two because PP starts on the second position. Now, if we change here 23 we will get nine
and you see it is still finding people. Though we're looking for capital to kept a piece and we have lower case
apiece. So that's Ah, that's the search. Pretty much the same as find.
Next function is substitute and it replaces one text ring with the other tech string
eso. It works like
replace in ah, inward, for example.
so to make an example So this is the text we're looking in, which we're doing the replacement.
So, for example, the old text is
The new one is just one B
lower case p
and then we are not going to change it
in the first instance. But in second instance
and we get this so it's very simple.
Also, if we would change this to one,
we would get this.
So it's Ah, it's very
six successfully designed
function that can really help you in in many situations.
the next function
we're talking about is T,
and it's ah,
very strange run.
it's basically checks if value is the text and returns the text if it is or returns double close meaning empty text. If it's not
so. The usefulness of this function is not quite clear at this moment, but you can very nicely use it in the Mac rose, um,
to eliminate anything that is not text. So, um,
it's just going to be t
out of this.
And we get this. And now if we expend this,
or logical value older. It looks like testes is illogical.
Think and it returns nothing.
And here it's also text. Now, if we change this
nothing happens because it's still recognizes. This is a number, so it doesn't matter if we have form. It'd the cell as ah
ah text. It sees the number and doesn't return it.
So the next function is text function
and text function. Basically,
convergence number two texting specified format
and you can enter Form it in many ways. But
let's see how it can be done.
So for example,
we can die Peter
And then here is what we want to change to text
and then we can say
we should have typed thes
here it is.
It gives us no decimal places because there are no decimal places.
But if we change this, we get
these things also
here we can say Ah,
we just removed these and remove these
and put your percent
and we get
percentage former thing automatically. Because this is 22 it is automatically said to be
2200% so if we want actually 22%.
It would take 0.22 we get 22%. So the possibilities are limitless. You just have to follow the standard X self former thing guide, and you get what you want.
Next function is trim
and trim removes multiple spaces from text drink. It is a simple is that nothing else
to see how it works.
We have one text that has deliberately multiple
spaces in it,
and it will correct it so you don't have
unwanted spaces in this text. So it works just like that. Nothing else.
And we have two more functions. The next money's upper
and upper simply converts. Old letter to upper case.
So we have a name
and we say upper
changes like this.
We get upper case. It is doing the opposite off lower function.
especially about it. But it can be used very successfully in
some other functions to get what you need and value converts text to number. It's simple. Is that so? This is nothing special
with value, so you can have this text and see
and you get the number in the former thing that exists in that cell. So if we want to get the correct form fitting, we would then form itself. We would click a number,
and then we would probably say something like this and we would get to the former thing we want. You see that? It it doesn't care if you have 1000 separators or
ah, whatever kind. It will get you just the number you want. And this concludes the lesson Number two in this marshal.
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