How to Display Results in a Specific Way in Excel

The image below shows how one of our website visitors wanted to display the results of his calculations because that’s how his boss most probably wanted it. In fact, he was contemplating of writing a macro for the job. As you can see that is not necessary at all. All you need to do is use ‘&’ as a concatenate function to display all kinds of text and then attach the relevant formula for the calculation result.

Display Data in Excel

Display Data in a Specific Manner

Watch the training video below to learn how to display results of a calculation in a specific way in MS Excel:

Leave a Reply

Your email address will not be published. Required fields are marked *