This article will demonstrate you how to remove the formatting of pasted text with macro and VBA in your word.
It happens a lot when you copy a text online, and you find the text is in rich formatting. For instance, there are repeating words, blank lines, tab characters, etc. Yet, such formatting can be quite annoying especially at times you don’t need. Naturally, you would remove the formatting manually each by each. However, what if the text is a really long one? Then the above method will...
Read more »
In Excel, you can use the icon sets to mark cells with different values. And in this article, we will talk about how to use this feature in Excel.
Icon sets is a very useful feature in Excel. It is also a small feature of the conditional formatting. Suppose now you need to mark cells for the sales volume in the worksheet.
Instead of ranking cells, now you can also use the different icons to mark different values in the cells, with icon sets, so to make these values more intuitive, as...
Read more »
When you forward emails in Outlook, “FW” will be added to the subject by default. If you dislike it, you can apply the following 2 approaches to disable “FW” prefix in subject.
As a rule, when we forward emails, the characters “FW:” will be inserted at the beginning of the email subject line. However, at times, for some reasons, we may hope to just forward the emails without “FW”. Of course, we’re able to remove it manually in the forwarding messages. But it’s a bit troublesome. Here 2...
Read more »
