Adding numbers to text!

[Rocketeer]

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

 

[Bob Phillips]

=A1&" "&B1

--
---
HTH

Bob


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

 

[Max]

One way
In C1, copied down:
=IF(COUNTA(A1:B1)=2,A1&" "&TEXT(B1,"0.00"),"")

 

[Rocketeer]

Thanks both for your help! It works perfectly now.

 

[Max]

Welcome, glad to hear that.