Concat Sheet:
Table 1: Using first name and last name, create email id in FirstName.lastname@techmil.com format.
Table 2: For elita apartments in bangalore, you have block, floor and flat details. Create Complete address in the required format.
Table 3: You have category_id and product_id in the table. Use both the columns to create Item_code in required format.
Find Characters:
Table 4: In the table, you have district state mapping. Identify cities having “garh”, “pur” and “ore” in the city names.
Table 5: In the table, you have email ids of some individuals. Identify individuals having email id from ‘gmail’, ‘yahoo’ and ‘hotmail’.
Text Break:
Table 6: Flight numbers and their departure and arrival airport code are mentioned in the table. Extract departure and arrival airport code in two different columns.
Table 7: Entry number of a college is consist of Year of entry, department code and roll number. Extract all the information in diffenent columns.
Table 8: Break full name into first name and last name.
Table 9: Get first name and last name from the email id.
Dataset-
Solution sheet -
2.2 Workbook - Text and date functions (Solution).xlsx
493.7 kB
