1

00:00:00,750 --> 00:00:04,100

Heidi it this time let me talk about the text formula.



2

00:00:04,140 --> 00:00:11,130

One of the very important formulas for presentation of DNA into a certain desired custom format in this



3

00:00:11,130 --> 00:00:18,000

case I have a couple of dates for June 2011 which I want to present in this form either Friday or Friday



4

00:00:18,210 --> 00:00:23,060

or 03 3 to to what indicates that turned off total of two.



5

00:00:23,130 --> 00:00:29,300

So the formula goes like this text first thing it asks for is the value.



6

00:00:29,400 --> 00:00:31,120

I choose the date value.



7

00:00:31,200 --> 00:00:35,200

Next it asks for what is the desired format of output.



8

00:00:35,370 --> 00:00:37,890

So in double quotation I give BD.



9

00:00:38,010 --> 00:00:40,920

BD four times the I close the double quotation.



10

00:00:40,980 --> 00:00:46,710

I close the bracket thereafter as soon as I press Enter what I get is Friday.



11

00:00:46,710 --> 00:00:53,130

Now how do I put in just tripled the I would have got the short form of the day and how they put just



12

00:00:53,340 --> 00:00:57,900

two dimes the letter D I would have got the actual deep seated.



13

00:00:57,990 --> 00:01:05,900

Similarly I can also play that formula if I wish to find out the month name I choose the date comma



14

00:01:06,230 --> 00:01:12,060

double gradation double double double double and close close the brackets and enter.



15

00:01:12,330 --> 00:01:19,110

So if you wish to find just the shorter form of the montanum you would have used just three times the



16

00:01:19,110 --> 00:01:20,250

letter M.



17

00:01:20,250 --> 00:01:26,640

Similarly if you want to find out the calendar month sequence of the month of June then just two m will



18

00:01:26,640 --> 00:01:32,850

be sufficient enough and goes without saying that if you had written text formula and chosen the date



19

00:01:32,940 --> 00:01:38,520

and then double wide double Y in the double condition you would have got the year 2011.



20

00:01:38,520 --> 00:01:45,180

Now what specifically is this format now this format text is the one which you generally get to see



21

00:01:45,180 --> 00:01:46,770

inside for myself.



22

00:01:47,720 --> 00:01:48,980

When I go to custom.



23

00:01:49,040 --> 00:01:55,460

So any of these format which is generally found in a custom format can be enclosed in the pair of double



24

00:01:55,460 --> 00:01:56,340

quotation.



25

00:01:56,360 --> 00:02:02,570

So for example if there is a format which I prefer to have it on my screen that aspect to date I can



26

00:02:02,570 --> 00:02:09,710

use a combination of the D M M M and Y Y Y in that sequence for example equal text choosing the date



27

00:02:10,130 --> 00:02:11,820

comma than double condition.



28

00:02:11,840 --> 00:02:15,200

I'm writing Deedy dot dot.



29

00:02:15,200 --> 00:02:16,850

Y y y y.



30

00:02:16,960 --> 00:02:20,750

I close the double tradition I close the bracket and I press enter.



31

00:02:20,780 --> 00:02:21,450

There you go.



32

00:02:21,500 --> 00:02:24,580

I have the date in 0 3 0 6 2011.



33

00:02:24,770 --> 00:02:33,830

And this is also useful when you are combining the data with the prefix word bit and then you're combining



34

00:02:33,830 --> 00:02:38,690

with actually did you notice it gets converted to a number.



35

00:02:38,690 --> 00:02:44,870

Now this will happen why because every valeted is a number so make sure that you apply the text formula



36

00:02:44,900 --> 00:02:46,590

before you choose the number.



37

00:02:46,640 --> 00:02:54,160

In this case using the hyphen M and M hyphen y y and close using the brackets.



38

00:02:54,180 --> 00:03:01,160

And so this way you have been able to concatenate or combine the word beat with the date that you wish



39

00:03:01,160 --> 00:03:03,750

to point to in the desired format.



40

00:03:03,770 --> 00:03:05,300

So that was text formal.