👉 len function is used for calculating the length of the text in the cell.
=Len(cell address) press enter. i.e. =Len(a1) press enter
👉 Left Function is used for show the left side of number, text which we want to show the digit
= left(cell address, number of character ) press enter
👉 Right Function is used for show the Right side of number, text which we want to show the digit
=Right(cell address, number of character ) press enter
now see this example here
9060473489 is number and its cell address is suppose a1 then
=len(a1) press enter result 10
= left (a1,5) press enter result 90604
= right (a1,5) press enter result 73489
=LEFT(a1,3)&"****"&RIGHT(a1,3) press enter result 906****489
👉 upper Function is used for convert the upper text
=upper (cell address) press enter
👉 Lower Function is used for convert the Lower text
=Lower (cell address) press enter
👉 proper Function is used for convert the proper format
=Proper(cell address) press enter
👉 Concatenate Function is used for Merge the more than two cell text, number
=concatenate(a1,"",b1) press enter
example suppose Jitsu , whose cell address is a1 and Kumar ,whose cell address is b1
so now we use the concatenate function =concatenate(a1," ",b1) press
enter the result will be jitsu Kumar
👉 how to add zero "0" before the number
=text(celladdress,"00000") press enter
this function is used for add the zero before the number and make a large digits such as 0000025,0000125,0001256,0014525,0114525 etc.
👉 how to write a large number in excel such as Ac no, adhar number or more than12 digits
then we convert the cell address format in text format
hi
ReplyDelete