how to mix text and cell in one cell

S

StellaW

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?
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
How To Have A Cell Be Blank If... 2
How copy a cell with mixed text (regular, bold, italic) with a fo. 1
Mixing number formats in one cell 5
Looking to added up based on a character from cell range 1
Combining Text From Cells 3
How to paste this down? 3

Top