LEN FUNCTION
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
LEFT FUNCTION
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
RIGHT FUNCTION
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
MID FUNCTION
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
TRIM FUNCTION
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
FIND AND SEARCH FUNCTIONs
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram VijayaRaghavan Venkatadri
Sekharipuram VijayaRaghavan Venkatadri
TEXT Function
Converts value into Text as per format specified
123.4567
0.4567
CONCATENATE and "&" Functions ("&" is also referred to as "AMPERSAND")
Sekharipuram
Venkatadri
Vijayaraghavan
Sales quantity - numbers
Sales price per unit
Sales Value
Required output:
Sales Value of 100 numbers at Rs.10 per unit is Rs.1,000
Answer -->
TEXTJOIN Function as a improvement over "&" and CONCATENATE
Sekharipuram
Venkatadri
Vijayaraghavan
Sekharipuram
Vijayaraghavan
VALUE Function
12345
UPPER, LOWER PROPER Function
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
CLEAN Function
Can someone give me junk data??
EXACT Function
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, report TRUE
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, reports True
36
40
38
43
Sekar
Sekar 6
Sekaripu 8
Sekaripuram Vija 16
tadri
tadri 6
nkatadri 8
havan Venkatadri 16
ripuram Vijayar
ripuram Vijayar
ripuram Vijayar 5 15
jayaraghavan Venkatadri 15 30
LEN Now Original
Sekaripuram Vijayaragavan Venkatadri 36 36
Sekharipuram Vijayaraghavan Venkatadri 38 40
Sekharipuram Vijayaraghavan Venkatadri 38 38
Sekharipuram Vijayaraghavan Venkatadri 38 43
FIND What FIND Fn Result SEARCH Fn Result
Sekhar #VALUE! #VALUE!
sekhar #VALUE! 1
Vijay 14 14
ragavan #VALUE! #VALUE!
raghavan #VALUE! 20
Raghavan 20 20
Text of two decimals 123.46
Text of percentages with 45.67%
two decimals
eferred to as "AMPERSAND")
SekharipuramVenkatadriVijayaraghavan
Sekharipuram Venkatadri Vijayaraghavan
100
10
1000
Sales Value of 100 numbers at Rs. 10 per unit is Rs. 1,000
and CONCATENATE
Sekharipuram:: Venkatadri:: Vijayaraghavan
Sekharipuram:: Vijayaraghavan Sekharipuram:: :: Vijayaraghavan
12345
SEKARIPURAM VIJAYARAGAVAN VENKATADRI
sekharipuram vijayaraghavan venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Can someone give me junk data??
FALSE
TRUE
FALSE
LEN FUNCTION
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
LEFT FUNCTION
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
RIGHT FUNCTION
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
MID FUNCTION
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
Sekaripuram Vijayaraghavan Venkatadri
TRIM FUNCTION
Sekharipuram
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
FIND AND SEARCH FUNCTIONs
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram VijayaRaghavan Venkatadri
Sekharipuram VijayaRaghavan Venkatadri
Sekharipuram VijayaRaghavan Venkatadri
TEXT Function
Converts value into Text as per format specified
123456789.4567
0.45678
CONCATENATE and "&" Functions ("&" is also referred to as "AMPERSAND")
Sekharipuram
Venkatadri
Vijayaraghavan
Sales quantity - numbers
Sales price per unit
Sales Value
Required output:
Sales Value of 100 numbers at Rs.10 per unit is Rs.1,000
Answer -->
TEXTJOIN Function as an improvement over "&" and CONCATENATE
Sekharipuram
Venkatadri
Vijayaraghavan
Sekharipuram
Vijayaraghavan
VALUE Function
12345
UPPER, LOWER PROPER Function
Sekaripuram Vijayaragavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sekharipuram Vijayaraghavan Venkatadri
CLEAN Function
Can someone give me junk data??
EXACT Function
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, report TRUE
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, reports TRUE
Compares two data and if Exact, reports True
36
40
38
77
Sekaripu
Sekari 6
Sekaripuram Vij 8
Seka 16
dri
katadri 6
Venkatadri 8
16
ripuram Vijay
ripuram
ripuram Vi 13 15
am Vijayaraghava 15 30
12 LEN Now
Sekaripuram Vijayaragavan Venkatadri 36 36
Sekharipuram Vijayaraghavan Venkatadri 38 38
Sekharipuram Vijayaraghavan Venkatadri 38 38
Sekharipuram Vijayaraghavan Venkatadri 38 38
FIND What FIND Fn Result SEARCH Fn Result
Sekhar #VALUE! #VALUE!
sekhar #VALUE! 1
Vijay 14 14
ragavan #VALUE! #VALUE!
raghavan #VALUE! 20
Raghavan 20 20
" " (Space) 13 13
case sensitive not case sensitive
Text of two decimals 123456789.46 123456789.457
Text of percentages with 45.68%
two decimals #NAME?
ed to as "AMPERSAND")
SekharipuramVenkatadriVijayaraghavan SekharipuramVenkatadriVijayaraghava
SekharipuramVenkatadriVijayaraghavan
Sekharipuram Venkatadri Vijayaraghavan
115
10
1150
Report
Sales Value of 100 numbers at Rs.10 per unit is Rs.1,000
sales value of115 rs.10 per unit is rs.1,150.00
CONCATENATE
True formula False Formula
SEKARIPURAM VIJAYARAGAVAN VENKATADRI
sekharipuram vijayaraghavan venkatadri
Sekharipuram Vijayaraghavan Venkatadri
Sita weds Ram
Sita weds Ram
FALSE
FALSE
TRUE
TRUE
FALSE
TRUE
Original
36
39
38
43
EARCH Fn Result
28
ot case sensitive
23456789.457
VenkatadriVijayaraghavan
The table below gives first and last names of several new LIBA India Limited employees. To
create an e-mail address for each employee, we follow the first letter of their first name by
their last name and add “@libaindia.com” to the end. Use text functions to efficiently create
the e-mail addresses. All the email ids should contain lowercase letters only.
(Do not use Auto
(Hint : Use ‘FIND’, ‘LEN’, ‘LEFT’ and ‘RIGHT’ functions)
Geetha Anantharaman Result should be [email protected]
You can write only one formula in one column and the final colum
Illustrated in the first four columns below (the illustration is for ex
Geetha Anantharaman 19 raman Geeth Geethramanlibaindia.com
Ian Botham
Sania Mishra
Sunil Gavaskar
Sunil Chetri
Kaaram Coffee
Sweet Kaaram
Syed Jirmani
Charles D'Souza
Washington Sundaram
Efgefgjagan Mohan
Abdklmpema Khandu
Yuiefghimanta Biswa
Klmklmnitish Kumar
Efgefgbhupesh Baghel
Yuiefgarvind Kejriwal
Yuiefgpramod Sawant
Abdefgbhupendra Patel
Klmefgmanohar Lal
Abdefgsukhvinder Singh
Yuiefghemant Soren
Klmyuisiddaramaiah
Tretrepinarayi Vijayan
Treabdshivraj Singh
Efgyuieknath Shinde
Treyuin. Biren
Yuiefgconrad Kongkal
Treabdpu Zoramthanga
Yuitreneiphiu Rio
Efgklmnaveen Patnaik
Abdtren Rangaswamy
Abdyuibhagwant Singh
Abdklmashok Gehlot
Abdefgps Golay
Tretremk Stalin
Abdtrek Chandrasekhar
Tretremanik Saha
Efgabdyogi Aditya
Abdyuipushkar Singh
Treefgmamata Banerjee
Klmv Vijayasai
Yuinabam Rebia
Efgpabitra Margherita
Efgmisa Bharti
Yuirajeev Shukla
Klmvinay Tendulkar
Abdramilaben Bara
Abdkrishan Lal
Efgsikander Kumar
Abdaditya Sahu
Klmnirmala Sitharaman
Yuielamaram Kareem
Klmsumitra Valmiki
Yuipiyush Goyal
Efgleishemba Sanajaoba
Efgwanweiroy Kharlukhi
Yuik Vanlalvena
Abds Phangnon
Klmsasmit Patra
Efgbalbir Singh
Efgrandeep Surjewala
Efghishey Lachungpa
Efgkr Rajeshkumar
Efgb Parthasaradhi
Klmbiplab Kumar
Efglaxmikant Bajpai
Klmr Krishnaiah
Klmsarbananda Sonowal
Klmfaiyaz Ahmad
Efgranjeet Ranjan
Yuinarhari Amin
Efgram Chander
Efgindu Goswami
Abddeepak Prakash
Efgjaggesh Lal
Yuibinoy Viswam
Abdkavita Patidar
Yuianil Sukhdevrao
Klmmanas Ranjan
Yuivikramjit Singh
Yuimukul Wasnik
Tres Kalyanasundaram
Abdd Damodar
Efgradha Mohan
Tres Niranjan
Yuibhubaneswar Kalita
Abdprem Chand
Yuiphulo Devi
Efgrambhai Mokariya
Efgdevender Paul
Yuijagat Prakash
Klmsameer Oraon
Klmlehar Singh
Trejose K
Efgjyotiraditya Scindia
Tredhananjay Mahadik
Yuisulata Deo
Klmsanjeev Arora
Trepramod Tiwari
Efgr Girirajan
Trek Keshava
Tresurendra Singh
Abdbeeda Masthan
Yuikamakhya Prasad
Treamarendra Dhari
Klmkt Rajkumar
Efgparshottam Rupala
Efgdeepender Singh
Abdmahua Maji
Abderanna Kadadi
Klmv Sivadasan
Abdsumer Singh
Klmudayanraje Bhosale
Abdmamata Mahanta
Klmraghav Chadha
Yuikc Venugopal
Efgtiruchi Siva
Yuikr Suresh Reddy
Tresangeeta Yadav
Efgalla Ayodhya
Yuirwngwra Narzary
Klmmanoj Jha
Efgsaroj Pandey
Abdmansukh L
Klmkartikeya Sharma
Yuishibu Soren
Klmk Narayan
Efgjohn Brittas
Efgdharmendra Pradhan
Klmbhagwat Karad
Klmsujeet Kumar
Klmdr Sandeep
Klmneeraj Dangi
Abdnr Elango
Klmb Lingaiah
Tredarshana Singh
Tremopidevi Venkataramana
Efgbirendra Prasad
Efgahmad Ashfaque
Efgs Jaishankar
Yuidhiraj Prasad
Yuirajeev Chandrasekhar
Abdpv Abdul Wahab
Klmkailash Soni
Efgprakash Javadekar
Efgmunna Khan
Yuiharbhajan Singh
Yuidr Manmohan
Klmanthiyur P
Yuijoginapally Santosh
Efgbaburam Nishad
Yuipilli Subhash
Yuiajit Kumar
Trekhiru Mahto
Efgjugalji Mathurji
Yuijairam Ramesh
Efgaa Rahim Khan
Yuiajay Pratap
Klmnarayan Rane
Efgniranjan Bishi
Klmashok Mittal
Klmghanshyam Tiwari
Efgkanimozhi Nvn
Efgvaddiraju Ravichandra
Abdk Laxman
Efgparimal Nathwani
Abdanil Hegde
Klmdineshchandra Anavadiya
Efgmallikarjun Kharge
Trep Santhosh
Yuil Murugan
Abdv Muraleedharan
Klmamar Patnaik
Klmrajendra Gehlot
Klmmm Abdulla
Klmmithlesh Kumar
Yuivemireddy Prabhakar
Treharivansh Narayan
Klmshaktisinh Gohil
Efgl Hanumanthaiah
Yuijebi Mather
Efgvivek Tankha
Abdpraful Patel
Abdprashanta Nanda
Klmkirodi Lal
Efgm Shanmugam
Klmhardeep Singh
Abdcm Ramesh
Treram Nath
Abdamee Yajnik
Tregc Chandrasekhar
Tredigvijaya Singh
Efgsharad Pawar
Klmashwini Vaishnaw
Klmbhupender Yadav
Abdp Wilson
Klmarun Singh
Efgkanakamedala Ravindra
Abdbashistha Narain
Abdnaranbhai Rathwa
Abdsyed Naseer
Klmrajmani Patel
Klmfouzia Khan
Abdcv Shanmugam
Trebl Verma
Tresatish Chandra
Klmhd Deve Gowda
Yuivandana Chavan
Efgr Dharmar
Klmbrij Lal
Yuishambhu Sharan
Abdsanjay Raut
Trem Thambidurai
Efgneeraj Shekhar
Trevivek Thakur
Efgpriyanka Chaturvedi
Yuin Chandrasegharan
Yuiseema Dwivedi
Yuisushil Kumar
Treanil Desai
Efgp Chidambaram
Abdgeeta Shakya
Treakhilesh Prasad
Klmimran Pratapgarhi
Tregk Vasan
Efgvijaypal Singh
Klmrajani Patil
Trevaiko
Treashok Bajpai
Abdkumar Ketkar
Abdanbumani Ramadoss
Abdanil Jain
Efgramdas Athawale
Treharnath Singh
Tresakal Deep
Trekanta Kardam
Abdnarasimha Rao
Abdanil Agrawal
Tresudhanshu Trivedi
Yuijaved Ali
Efgram Gopal
Efgjaya Bachchan
Klmkapil Sibal
Efgjayant Chaudhary
Klmramji Gautam
loyees. To This will be an Assignment for all Groups
Last date of submission will be announced later
iently create You are supposed to write the formulas for one row (Row No. 12)
Validate it for Row No. 13
Then you should copy the entire set of formulas for all other rows
and the final column should contain the final result
e illustration is for example only, it is not part of the solution)
libaindia.com
Row No. 12)
ll other rows
