TEXT and String Functions in Excel
Home Excel Excel Resources TEXT and String Functions in Excel
TEXT and String Functions in Excel Courses
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…
TEXT and String Functions in Excel Resources
