ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Use text and numbers in the same cell

By using text and numbers from several different cells in the same cell you will be able to present your worksheet results in a nice way. To combine the results from two or more cells in one cell, you will have to use the &-function between the different expressions in the formula.

When you combine text and numbers in this way, you loose the number format unless you convert your numbers to text. This is done with the help of the TEXT(number,format)-function where the argument number is the value that is going to be converted to text, and the argument format describes how the number is to be formatted. You can use the same number formats as usual in Excel, or you can use your own custom number formats. It's not necessary to create the custom number format in advance.

Example:
="Due date : "&TEXT(TODAY()+15,"dd.mm.yyyy")
="Lastname, Firstname : "&C1&", "&B1)

 

Document last updated 2000-02-04 12:45:07      Printerfriendly version

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address