Adding numbers to text!
 

Hi!

Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.

C1: Text 1.05
C2: Text 2.94
C3: Text 3.14

That is "Text " and "1,05"
Is there a print function or similar?

Kind Regards

Adding numbers to text!
 

=A1&" "&B1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rocketeer" wrote in message
...
Hi!

Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.

C1: Text 1.05
C2: Text 2.94
C3: Text 3.14

That is "Text " and "1,05"
Is there a print function or similar?

Kind Regards

Adding numbers to text!
 

One way
In C1, copied down:
=IF(COUNTA(A1:B1)=2,A1&" "&TEXT(B1,"0.00"),"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rocketeer" wrote:
Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.

C1: Text 1.05
C2: Text 2.94
C3: Text 3.14

That is "Text " and "1,05"
Is there a print function or similar?

Kind Regards

Adding numbers to text!
 

Thanks both for your help! It works perfectly now.


"Max" wrote:

One way
In C1, copied down:
=IF(COUNTA(A1:B1)=2,A1&" "&TEXT(B1,"0.00"),"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rocketeer" wrote:
Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.

C1: Text 1.05
C2: Text 2.94
C3: Text 3.14

That is "Text " and "1,05"
Is there a print function or similar?

Kind Regards

Adding numbers to text!
 

Welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rocketeer" wrote in message
...
Thanks both for your help! It works perfectly now.