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.
Watch the training video below to learn how to display results of a calculation in a specific way in MS Excel: