Adding numbers to text!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rocketeer - 11 May 2008 23:34 GMT

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

Reply to this Message

Bob Phillips - 12 May 2008 00:17 GMT

=A1&" "&B1

Signature

---
HTH

Bob

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

> Hi!
>
[quoted text clipped - 11 lines]
>
> Kind Regards

Reply to this Message

Max - 12 May 2008 00:25 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Let's say I have a text called "Text" in column A1:A3.
> In column B1:B3 I have a formula counting number of
[quoted text clipped - 9 lines]
>
> Kind Regards

Reply to this Message

Rocketeer - 12 May 2008 07:53 GMT

Thanks both for your help! It works perfectly now.

> One way
> In C1, copied down:
[quoted text clipped - 12 lines]
> >
> > Kind Regards

Reply to this Message

Max - 12 May 2008 13:57 GMT

Welcome, glad to hear that.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thanks both for your help! It works perfectly now.

Reply to this Message

Rate this thread: