Can an excel cell with text refer to another?

  Simply Sauvignon 14:36 08 Mar 06
Locked

I'm trying to set up a table that refers to a particular cell with a numerical value.
The calculations are straightforward, but can I insert the numerical value into the text cell that is describing the data (so that it changes automatically)?
...Ideally I would like to avoid inserting another column?
Any ideas folks? Thanks in advance!

  Taff™ 16:13 08 Mar 06

Concatenate function - type "Concatenate" into help and you will see an example which should help you. Post back if you get stuck.

  Simply Sauvignon 19:12 08 Mar 06

Thanks Taff - that's spot on!

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017