Harold & Francesco,
Thank you. Just what I needed.
Harold Fuchs wrote:
2008/8/5 Nicholas <[EMAIL PROTECTED]>
Hi all,
I am currently using OOo2.4 but have not found a way in Calc to do the
following:
Inserting text that includes reference to a value in another cell.
Example:
In Cell A1 with the value "CAR"
In Cell B1 with the formula "=$A$1"
In Cell C1 there is the text displayed is "The item requested is a CAR",
where the word car is a value from the cell B1.
Can anyone tell me how to enter this into cell C1? or is this feature only
in OOo3?
In C1 put the formula ="The item requested is " & B1
The "&" is the "concatenate" operator used for joining text strings. This
certainly works in my version 2.4 and I hope will continue to work in v3. It
also works if A1 has a numeric value.
--
Nicholas A. Suppiah
Training & Certification Manager
Open Source Competency Centre (OSCC) MAMPU
Tel: 603 8319 1200 Fax: 603 83193206
URL: http://opensource.mampu.gov.my
---
Join OSCC MAMPU Mailing Lists
http://lists.oscc.org.my/mailman/listinfo/oscc-discuss
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
