We have to use various excel functions for importing such as Text functions ,Lookup functions ,Date and Time functions, If and related functions etc
Note: In Excel we can use FORMULATEXT() function to know the functions that we have used in each cells.
a) Right function is used to extracts a given number of characters from the right side of a supplied text string. We have to pass the cell ID and the number of characters from the we need from the right end.
b) Left function is used to extracts a given number of characters from the left side of a supplied text string. We have to pass the cell ID and the number of characters from the we need from the left end.
c) Concatenate function is used to join the characters in different cells to a single cell.
d) Upper ,Lower and Proper are alphabetic functions used to change the cases of data in each cell
e) We can replace certain characters with our requirements by specifying the position ,number of characters should replaced and the new text.
f) Vlookup is a function that makes Excel search for a certain value in a column , in order to return a value from a different column in the same row. The arguments we have to pass in vlookup() are :-Value you are looking for (lookup_value) ,The range of cells that make up the table (table_array) ,The number of the column from which to retrieve a result (column_index),TRUE/FALSE for checking the exact match.
g) The IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. IF function helps us to get a result by comparing the existing value with our conditions. Using multiple IF statements in Excel (nested IF functions) we can create more elaborate logical tests for our data.
h)The Excel AND function is a logical function used to require more than one condition at the same time. This function will return the desired result only when all the arguments of the function is true.
i)The OR function is a logical function to test multiple conditions at the same time. This function will return the desired result when any of the arguments of the function is true.
j) The NOT function is a logical function used when you want to make sure one value is not equal to another.
