Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
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.
00:11
And, um,
00:14
it's
00:16
see it to the
00:18
one
00:19
group off names first name, last name.
00:22
The civilian entered in cells and they have some typing errors.
00:27
I'm not typing in in the meaning that
00:32
some of the letter has been time correctly. But the case of the letters hasn't bean typed properly
00:38
and we want income. See tohave name,
00:42
first name and last name separated by space we have seen before.
00:46
Um and then, uh
00:48
ah,
00:49
everything should be done properly.
00:53
And for that, we're going to use a text function called proper
00:59
and let's go to formulas
01:02
and let's go to text ones
01:06
and just die proper
01:08
and the proper functions does. Very simple thing. Takes the text. You're referring to a CZ. An argument
01:17
makes the first letter always.
01:19
Ah,
01:23
uppercase and the rest of the letters lower case. So we can say a proper out of this
01:30
and then we can see
01:33
and
01:36
and we can put
01:38
lank here
01:40
and then again and
01:42
and again,
01:44
predator
01:45
off
01:46
this
01:49
report. Press this and get it, Mike White. Now, if we
01:55
copy this,
01:57
we got everything. Perfect.
02:00
We double click here.
02:02
Just to make this comb is why does need it for all the
02:08
these names fit in without crossing into next gone
02:15
and let me show you the other way to do it.
02:16
And I'm going to show you the other way as well. So the third way.
02:22
So we can also do
02:24
proper
02:25
I want off.
02:28
And then this
02:30
and
02:31
this and
02:35
this
02:39
and then we copy this
02:43
and look, we got the same results.
02:46
So this is one very nice thing about functions in
02:51
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.
03:00
So I put the proper
03:02
and then
03:06
the formula within as an argument and we got the string. So Excell first calculates
03:13
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.
03:24
We can use
03:28
Ah, the another function so we can see
03:32
proper.
03:35
And then
03:37
we can use another function which is
03:43
Captain eight
03:47
and then
03:50
this
03:51
comma
03:53
coma
03:55
this close brackets once, twice months, we get the black one. You know that it is the last one,
04:04
and you just press enter.
04:06
Let's do the copy
04:09
and we get the same result. So function can Captain eight
04:14
basically puts together strings,
04:16
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.
04:27
And it does the same thing, absolutely the same thing as adding strings together or texts together with end
04:38
sign.
04:40
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,
04:56
sometimes even more so you can have a function within function within function and so on.
05:01
So this is how it works. We achieve the same thing in a three different ways,
05:06
and you can say that each one of these is better than the other. It's they just work in the same way.
05:14
So this is how human it'll manipulate text in excel.
05:19
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
05:40
usage of excel.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor