sum

69
36
52
45
85
45
85
45
78
540

date upper
sihas SIHAS
deepa DEEPA
Ashis ASHIS
gopl GOPL
karan KARAN
pooja POOJA

data Isnumber
78A4k FALSE
uttam FALSE
656F FALSE
H026 FALSE
7521 TRUE
3652R FALSE

25
36
85
 45
22
56
77
57

sum 403
Average 50.375
max 85

First name midName

Rajib
kumara
parad kumar
banitha

due
First name 30
Rajib 40
kumara 55
parad 31
banitha

First name
Rajib
kumara
pradeep
banitha
45225

800
400

7852
542
5485
weekness
wool

kaju sharma
475 256
kumar das
 Basic function
sun average max min counata countblank product

sum Average max min count counata

69 69 69 69 69 69
36 36 36 36 36 36
52 52 52 52 52 52
45 45 45 45 45 45
85 85 85 85 85 85
45 45 45 45 45 45
85 85 85 85 85 85
45 45 45 45 45 45
78 78 78 78 78 78
540 60 85 36 9 9

text function

upper low proper Text Isnumber low concatenate exact replace

lower Proper
sihas Sihas
deepa Deepa
ashis Ashis
gopl Gopl
karan Karan
pooja Pooja

Isnumber
Istext
TRUE
TRUE
TRUE
TRUE
FALSE
TRUE

Text
concatenate

lastName concatenate
khana Rajibkhana
dasgupta kumaradasgupta
bas paradkumarbas
bani banithabani

Final text
Rajib 30days recquired to complited
kumara 40days recquired to complited
pradeep 55days recquired to complited
banitha 31days recquired to complited

exact

mirror exact
rajib FALSE
kumara TRUE
pradeepa FALSE
banitha TRUE
1546 FALSE

800 TRUE
400 TRUE

LEN

4
3
4
 8
4

TRIM
kaju sharma
475 256
kumar das
countblank product
69 69
36 36
52
45 45
85 85
45
85 85
45 45
78 78
0 6.63323E+15

mid left right