How to Add Text to the Beginning or End of all Cells in Excel
There may be instances where you need to add the same text to all cells in a column. You might need to add a particular title before names in a …
Formulas
How to Remove Text after a Specific Character in Excel?
When editing or cleaning data in your worksheet, one often needs to trim and remove certain parts of strings, either for formatting consistency or to make the dataset look neat …
Count How Many Times a Word Appears in Excel (Easy Formulas)
One common requirement when working with large datasets is counting how many times a particular word or value appears. You may need to know how many times the word appears …
How to Reverse a Text String in Excel (Using Formula & VBA)
Reversing a string may not have many real-world applications, especially when working with spreadsheets. That is why you will not find any built-in function for this in Excel. But there …
How to Convert Radians to Degrees in Excel (Easy Formula)
When working with mathematical data, there might be instances where you need to work on angles. Excel has a number of built-in trigonometric functions that let you easily calculate the …
How to Generate Random Numbers in Excel (Without Duplicates)
Randomness is often just as necessary as order and symmetry, whether you are dealing with life or an Excel worksheet. Sometimes, you need it to ensure every value has an …
How to Merge First and Last Name in Excel?
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient. This is because it makes filtering and querying easier. However, there may …
How to Add Days to a Date in Excel
You may have come across situations where you needed to add a certain number of days to a date. It’s a common use case for people to add 7 days …
How to Remove Commas in Excel
Commas serve multiple purposes when working with spreadsheets. They make numbers more readable. For example, the number 1,452,346 is much clearer than the number 1452346. Commas also help delimit related …
How to Insert Square Root Symbol in Excel?
Every software in the Microsoft Office package comes with its own purpose and application. Just like MS Word was built for word processing, MS Excel has been created to work …
How to Calculate Standard Error in Excel?
Most people use spreadsheets software such as Microsoft Excel to process their data and carry out their analysis tasks. When performing an analysis of data, a number of statistical metrics …
How to Filter as You Type in Excel (With and Without VBA)
Excel has some powerful Filter options (with inbuilt filter, advanced filter, and now the FILTER function in Office 365). But none of these options actually filter as you type (i.e., …