Articles on Excel
This is a Microsoft Excel training tutorial on how to calculate percentages correctly in any version of Excel. Lean three cases you can use for all situations and learn how to calculate percentages correctly in Excel.
This is a quick tutorial on how to replace characters from a text string in Microsoft Excel. The substitute function is a very useful tool for replacing characters or words from strings of text. Here is an example how to use substitute to replace unwanted characters or words from a text.
This is a quick tutorial on how to combine first name and last name in Excel. You can use it to create email addresses from a list of names for example. To combine strings of text or values in cells we can use the CONCATENATE function.
This is a tutorial on how to round time in Excel. This can feel a bit tricky if you are not familiar with how Excel handles time formatted data. Now we can’t just go ahead and use the ROUND function which might feel like the obvious choice. We need a different set of tools for this, because for Excel, data formatted as time behaves in a different way.
Wondering how to remove the first word in of a text Excel? Or how to remove the first words dynamically in Excel, if the length of the words varies? No problem! You can achieve both pretty easily if you understand the functions RIGHT, LEN and SEARCH.
If you need to get the first word of any text in Excel, this is a handy quick tip for you. In this post I will show you how to get the first word or any number of characters of a text in Excel.