1
00:00:00,00 --> 00:00:04,000
Hey everyone this is Aprajita back again 
from excelchamps today we are

2
00:00:04,100 --> 00:00:08,900
going to talk about a few text functions 
which are given in excel so lets get started

3
00:00:09,000 --> 00:00:13,800
first of all we have length function

4
00:00:13,900 --> 00:00:18,700
now here I have few text which are numbers 
date and text as well now we will

5
00:00:18,800 --> 00:00:23,600
use the length function to get the lenght 
of these characters I'll use length I just 
need to

6
00:00:23,700 --> 00:00:28,500
select the cell where my text is located 
so it is B4 here so I'll press

7
00:00:28,600 --> 00:00:33,400
enter now the length of this text is five 
which is correct so when I

8
00:00:33,500 --> 00:00:38,300
drag this down I have here different types 
of text when it is blank

9
00:00:38,400 --> 00:00:43,200
it gives me zero similalry here it has included 
the spaces as well hello

10
00:00:43,300 --> 00:00:48,100
first five and than one space and two exclamation 
sign a total of eight here

11
00:00:48,200 --> 00:00:53,000
this is your trick since every date is a 
number in excel when I change

12
00:00:53,100 --> 00:00:57,900
into a number format here it is a five digit 
number so it has given

13
00:00:58,000 --> 00:01:02,800
me five similarly signs included this is 
three this is again

14
00:01:02,900 --> 00:01:07,700
three and here it has included dot and 23 
so it has a length of

15
00:01:07,800 --> 00:01:12,600
six characters now the next function is

16
00:01:12,700 --> 00:01:17,500
search function now this function is non-case 
senstive lets have a look when I use

17
00:01:17,600 --> 00:01:22,400
the search function I want to search this 
text from B5

18
00:01:22,500 --> 00:01:27,300
so I'll press enter when I drag this down 
I get the answers now here since this is 
no

19
00:01:27,400 --> 00:01:32,200
non-case senstive so it has given me an error 
since I have choosen blank to find out in 
blank

20
00:01:32,300 --> 00:01:37,100
here the esclamation sign is at the seveth 
position so now this is going to give

21
00:01:37,200 --> 00:01:42,000
me the first occurrence of this letter that 
is the first esclamation sign

22
00:01:42,100 --> 00:01:46,900
similarly here it has given me fourth position 
now you will notice that one is also

23
00:01:47,000 --> 00:01:51,800
like my date is staring from one so why not 
one so again

24
00:01:51,900 --> 00:01:56,700
I'll change it into the number format here 
and you will see that one is occurring

25
00:01:56,800 --> 00:02:01,600
at forth position so it has given me four 
similarly here I wanted to find out the

26
00:02:01,700 --> 00:02:06,500
location of zero it is at the third position 
here zero is at two

27
00:02:06,600 --> 00:02:11,400
it has given me the first occurence that 
is at the second position similarly here

28
00:02:11,500 --> 00:02:16,300
zero point two I wanted to look out for two 
number three numbers actualy zero point two

29
00:02:16,400 --> 00:02:21,200
so it is starting from third position my 
this zero is starting from third position 
so it has given

30
00:02:21,300 --> 00:02:26,100
me three here again my text is starting from 
capital h and here I have

31
00:02:26,200 --> 00:02:31,000
written h it has given me one when I change 
capital h it is again given me one

32
00:02:31,100 --> 00:02:35,900
since this is not case-sensitive so it is 
giving me the first occurence

33
00:02:36,000 --> 00:02:40,800
similarly we have the function called find 
the only difference

34
00:02:40,900 --> 00:02:45,700
is that this is case-sensitive again the 
same syntex I use find find this

35
00:02:45,800 --> 00:02:50,600
text in this cell and press enter now it 
will give me the

36
00:02:50,700 --> 00:02:55,500
same answers except here here we had a error 
in the search function

37
00:02:55,600 --> 00:03:00,400
but here it has given me one and you will 
notice here when I was looking for the

38
00:03:00,500 --> 00:03:05,300
small h it has given me four and when I chnage 
it to capital h and enter

39
00:03:05,400 --> 00:03:10,200
it will give me one so this is the case-sensitive 
function which does the same thing

40
00:03:10,300 --> 00:03:15,100
as the search function does the next function 
is

41
00:03:15,200 --> 00:03:20,000
left function as the name suggest this function 
helps to extract

42
00:03:20,100 --> 00:03:24,900
account of specific digits or numbers or 
alphabets from a given

43
00:03:25,000 --> 00:03:29,800
text for example I want to extract the five 
alphabets from

44
00:03:29,900 --> 00:03:34,700
this word from the left side what I am going 
to do is I'll use my function

45
00:03:34,800 --> 00:03:39,600
left and select this text since I need the 
five characters I

46
00:03:39,700 --> 00:03:44,500
simply type five and enter and this is given 
me five similarly when I drag this down

47
00:03:44,600 --> 00:03:49,400
it has given me the five characters from 
this text and when I change this to lets 
say

48
00:03:49,500 --> 00:03:54,300
eight it has given me the eight characters 
and similarly here including the spaces

49
00:03:54,400 --> 00:03:59,200
in the same way we have mid function

50
00:03:59,300 --> 00:04:04,100
this is use to get the middle characters 
for an example here I want to get the

51
00:04:04,200 --> 00:04:09,000
middle three characters now here I'll have 
to give the two inputs what is

52
00:04:09,100 --> 00:04:13,900
the staring number and the number of characters 
it should give me for an example I want

53
00:04:14,000 --> 00:04:18,800
to pick the middle values starting from three 
so the third

54
00:04:18,900 --> 00:04:23,700
character is c so when I press here three 
it will start

55
00:04:23,800 --> 00:04:28,600
extracting from the third character and I 
need the five characters and press

56
00:04:28,700 --> 00:04:33,500
enter so it will start from the third character 
as I said three and count the

57
00:04:33,600 --> 00:04:38,400
next five characters which is cel capital 
c and h so it has given me

58
00:04:38,500 --> 00:04:43,300
the middle five values from this text similary 
lets try something else now here

59
00:04:43,400 --> 00:04:48,200
I want this to start from my sixth position 
so it will start

60
00:04:48,300 --> 00:04:53,100
counting from the sixth digit and give me

61
00:04:53,200 --> 00:04:58,000
the five character which is exce including 
the spaces

62
00:04:58,100 --> 00:05:02,900
similarly the right function again this is 
use to get

63
00:05:03,000 --> 00:05:07,800
the desired number of characters from the 
right direction so here

64
00:05:07,900 --> 00:05:12,700
I'll select this and I want to get the last 
seven characters from the

65
00:05:12,800 --> 00:05:17,600
right side so I got my answers now the

66
00:05:17,700 --> 00:05:22,500
next function is upper function now here 
you will see that I have a few text

67
00:05:22,600 --> 00:05:27,400
written here which is in the like lower case 
now I want to change this text into

68
00:05:27,500 --> 00:05:32,300
the upper case so here comes the upper function 
I'll use the upper and simply select

69
00:05:32,400 --> 00:05:37,200
my text and press enter now my text is converted 
to the upper case I drag this down

70
00:05:37,300 --> 00:05:42,100
and my text will be converted to upper case 
similarly

71
00:05:42,200 --> 00:05:47,000
I have the lower function now here you will 
notice that my formating is well done

72
00:05:47,100 --> 00:05:51,900
that is h is captial e is captial now I want 
to change everything to the lower case

73
00:05:52,000 --> 00:05:56,800
so I'll use the lower function and press 
enter now everythig is converted to the

74
00:05:56,900 --> 00:06:01,700
lower case in my output in the same way we 
have proper

75
00:06:01,800 --> 00:06:06,600
function now this is my personal favourite 
now this proper function capitalizes the 
first

76
00:06:06,700 --> 00:06:11,500
alphabet of every word for example I'll use 
this proper and select my text

77
00:06:11,600 --> 00:06:16,400
now see h is capital e is capital similarly 
when I drag this

78
00:06:16,500 --> 00:06:21,300
down k is capital l is capital and similary 
here the first letters are

79
00:06:21,400 --> 00:06:26,200
capitalized and my and my text is well formatted

80
00:06:26,300 --> 00:06:31,100
last we have the rept function now this function 
is use to repeat

81
00:06:31,200 --> 00:06:36,000
a text or a number to a desired number of 
times for an example here I'll use

82
00:06:36,100 --> 00:06:40,900
the rept function to repeat this text how 
many times I have

83
00:06:41,000 --> 00:06:45,800
mentioned in B5 and press enter ten times 
now this has repeated this sign

84
00:06:45,900 --> 00:06:50,700
ten times similary now when I drag this down 
this will repeat my

85
00:06:50,800 --> 00:06:55,600
plus sign four times lets try this than  
I drag this down again my twenty five

86
00:06:55,700 --> 00:07:00,500
is repeated five times and this ec character 
is repeated six times

87
00:07:00,600 --> 00:07:05,400
I hope you like this video thank you for 
watching please don't forget to like comment 
and share

88
00:07:05,500 --> 00:07:08,900