how to mix text and cell in one cell
 

Can I input in a cell:
Create tablespace $A1 datafile '$B1' size $C1 REUSE.
and expect the result to be ==
Create tablespace TS_TEMP datafile '/opt/oradata_sid/temp.bdf' size 799M
REUSE.

In other word, can I mix text and referencing-cells in one cell instead of
concatenating individual cells?
--
StellaW

how to mix text and cell in one cell
 

hi
use the ampersand symble
="create tablespace " & $A1 & " datafile " & $B1 & " Size " & $C1 & " Resue"

Be sure to include spaces inside the quotes so that it will read like a
sentence ie not run words togeather.

Regards
FSt1

"StellaW" wrote:

Can I input in a cell:
Create tablespace $A1 datafile '$B1' size $C1 REUSE.
and expect the result to be ==
Create tablespace TS_TEMP datafile '/opt/oradata_sid/temp.bdf' size 799M
REUSE.

In other word, can I mix text and referencing-cells in one cell instead of
concatenating individual cells?
--
StellaW

how to mix text and cell in one cell
 

True.

& is shorthand for the CONCATENATE function.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"FSt1" wrote:

hi
use the ampersand symble
="create tablespace " & $A1 & " datafile " & $B1 & " Size " & $C1 & " Resue"

Be sure to include spaces inside the quotes so that it will read like a
sentence ie not run words togeather.

Regards
FSt1

"StellaW" wrote:

Can I input in a cell:
Create tablespace $A1 datafile '$B1' size $C1 REUSE.
and expect the result to be ==
Create tablespace TS_TEMP datafile '/opt/oradata_sid/temp.bdf' size 799M
REUSE.

In other word, can I mix text and referencing-cells in one cell instead of
concatenating individual cells?
--
StellaW