Formula, text and currency in same cell

M

mike

Does anyone know how do combine a formula, text and currency in the
same cell? I'm trying to get a cell that displays like this:

Average monthly income is: £1,000

by combining 3 things:

Text ("Average monthly income is: ")
Formula (=A1/12, where A1 is total annual income)
Currency (figure displayed with £ and comma separator)

Any help would be great. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top