Exercises:1 and 2

In this exercise, you can gain the knowledge about using TEXTJOIN function to combine texts:

Note:
when you try to use the functions to combines the text/names in one cell which are in the different cells in the table shown like the above, you can use the tricky in writing functions to have exact results to every single rows by dragging the written functions which has used 'at once' method such as given the above example. So, you can use dragging method to get the results for all other rows in the table as well.
​
​Syntax for TEXTJOIN:
Have a look at the syntax has explained below and it will be useful to understand the fact of the function to use in Excel. 

If anyone has got any questions regarding this exercise, state all your questions through comments box and we will answer for all the questions as soon as possible on this website. 

Execise 2

In this exercise, you can gain the knowledge about using multiple functions in one line:

When you try to write functions 'at once' method to find the exact result for the questions below, you have to get the idea of it or think the exact logic of the situations and then only you would be able to get the results as required. So, here I have given the example of functions for all three type of different sections are working as expected.

The above exercise shows you about retrieving the title only from whatever it is in the full name column.

The above exercise shows you about retrieving the First-name only from whatever it is in the full name column.

The above exercise shows you about retrieving the Last-name only from whatever it is in the full name column.