Two different values in a single cell...

P

Patrick

Hi,

Is it possible to have two different values (coming from
another sheet) in a single cell? For example,

0.87 (0.97)

In that case 0.87 comes from a cell on sheet1 and 0.97
from a cell on sheet2. Thanks for the help.

Patrick,
 
G

Guest

Hi

You can concatenate two results into one cell. This makes it inot a text
cell, however, so you cannot do maths on it quite so easily. To join the
info, just use the CONCATENATE function, or the & sign
=A2&" " &A3
You may also need the TEXT funtion, depending on what format you want the
result to be
 
B

Bob Phillips

Patrick,

Try

=TEXT('Sheet1'!A1,"0.00") &" "&TEXT('Sheet2'!A1,"(0.00)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

Hi,

Thanks it works very well...

Patrick,
-----Original Message-----
Patrick,

Try

=TEXT('Sheet1'!A1,"0.00") &" "&TEXT('Sheet2'!A1,"(0.00)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
G

Guest

Hi,

Thanks it works very well...

Patrick,
-----Original Message-----
Patrick,

Try

=TEXT('Sheet1'!A1,"0.00") &" "&TEXT('Sheet2'!A1,"(0.00)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Top