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…
By signing up, you agree to our Terms of Use and Privacy Policy.
By signing up, you agree to our Terms of Use and Privacy Policy.
Valuation, Hadoop, Excel, Web Development & many more.
डाउनलोड SUBSTITUTE function in Excel Template
This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy