Excel Formula

Excel Formula

Code

=CODE(“A”)        OR           =CODE(“a”)

=65                                         =97

Char

=CHAR(65)          OR           =CHAR(97)

=A                                           =a

Exact

=EXACT(“RAM”, “Ram”)           FALSE

=EXACT(“RAM”, “RAM”)          TRUE

Find

=FIND(“a”, “Ram Kumar Das”)         =2

= FIND(“a”, “Ram Kumar Das”,3)    =8

Left

=LEFT(“Ram Kumar Das”,3)

=Ram

Right

=RIGHT(“Ram Kumar Das”,3)

=Das

Right Left

=RIGHT(LEFT(“Ram Kumar Das”,9),5)

=Kumar

Concatenate

=CONCATENATE("Ram"," ","Das")

=Ram Das

Upper

=UPPER("Ram Kumar das")

= RAM KUMAR DAS

Lower

=LOWER("RAM KUMAR DAS")

= ram kumar das

Proper

=PROPER("RAM KUMAR DAS")

= Ram Kumar Das

Search

=SEARCH("Kumar","Ram kumar Das")

=5

Replace

=REPLACE("Ram kumar Das",5,5,"Kanta")

= Ram Kanta Das