View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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