TEXT and String Functions in Excel

What is TEXT and String Functions in Excel

In excel Text or String and Numerical data’s are different from each other. To work two different sets of data we have two different categories of functions. So to work with Test & String data we have formulas like LEN, FIND, PROPER, LEFT, RIGHT, MID, SUBSTITUE, etc…

Each function has its special features, FIND function to find the position of the mentioned character, LEN function to find the number of characters in the supplied cell, CONCATENATE function to combine two values etc…