Thread: Cell-Reference in a text-statement within an excel-worksheet

Hi Folks,

i have a excel-worksheet with different informations in different columns.
Now i have a statement like this:

CREATE FACT "<fact_name>" [DESCRIPTION "<description>"] IN FOLDER "<location_path>" [EXPSOURCETABLES "<sourcetable1>" ] FOR PROJECT "<project_name>";

Its not a excel-formula, but i want to fill the variables in brackets <> with the values from different columns. So, for every row in my excel-worksheet i need this statement, filled with the related values from the corresponding row.
I've tried it already , but without success:

="CREATE FACT "&(H103)&" ...;"

-- i used H103 as example for column H and row 103 --

What is wrong or how to change this statement ?

Thanks in advance

Frank

The formula you've posted should work fine - what problem is it giving you?

Hi Andrew,

problem is, that the formula stays as posted, when i confirm the cell with return. The reference (here: H103) wont be replaced with the value out of the cell H103. Is it a question of cell-format ?

What i want is:

CREATE FACT "this_is_the_sample_fact" ...

as result, when i entered the statement and confirm with return.

Thanks. My mistake. The cell-format was correct, but there was a blank in front of the =