Home

Combining text and a formula in a single cell

chrisp
New Contributor

Combining text and a formula in a single cell

I need to combine a bit of text, followed by a formula in a single cell.  For example, I  have a multi-worksheet spreadsheet that uses data from page 1 to fill in the same data on pages 2 & 3; part numbers, customer name and the like.

I want a single cell on pages 2 & 3 to read "Revision (='SETUP-1'!R4), so that the revision on page one (Setup-1) will show up preceeded by the word "Revision".

 

How is this done.

Yers trooly, Excel weenie-still-learning.

2 Replies

Re: Combining text and a formula in a single cell

Hi @chrisp

 

="Revision "&'SETUP-1'!R4

Highlighted

Re: Combining text and a formula in a single cell

Most excellent, works nice, so simple (I knew that!!!) and thanks much for the quick reply.

ChrisP.

Related Conversations
Cost estimator for small scale catering
Louisa Dira in Excel on
12 Replies
How to add the dates using the time criteria ?
Aditya Jadhav in Excel on
7 Replies
This calculation format driving me nuts
jjdrake in Excel on
6 Replies
Having an Issue with Excel hour/time formatting
Mike Button in Excel on
13 Replies