Functions

The TEXT function in excel is quite a lot used formula for converting a number or a numeric value in a specific text format. This… Read Article

Many a time, while working with numbers in excel, it keeps the numbers in a text format itself. This usually happens when we extract and… Read Article

The Excel TRIM function is an amazing formula provided by Microsoft in its excel versions to remove extra spaces in a sentence in Excel. This… Read Article

Many a time, while working in excel you may find a necessity to repeat a particular text string, number, or symbol for a particular number… Read Article

Many a time, you may want to convert the characters/letters in a sentence into upper case (i.e. capital letters) in Excel. Changing the entire sentence… Read Article

Many a time, a need may arise to quickly convert a sentence in lower or upper or mix case into a proper format. To achieve… Read Article

Many a time, while working with texts in excel, you may get the sentence in capital letters or not in a proper case. In that… Read Article

Many a time, while working in excel an excel user may face a challenge about how to calculate or count the total number of characters/letters… Read Article

In our previous blogs, we had learned about how to use the excel LEFT formula to extract a specific number of characters from the beginning… Read Article

In a previous blog, we had learned how to extract the text from the left of a string with the help of excel’s LEFT function.… Read Article

This blog covers one of the most used formulas in Excel viz. the excel LEFT function. The LEFT function, as the name itself suggests, is… Read Article

In our previous blog, we learned about the FIND function in excel which finds the position of a string. The SEARCH excel function is exactly… Read Article