Column function
 

I want to use the column function to determine the column number of a cell
reference at another cell location. That is to say, cell F5 has the value of
another reference CZ108. Can some one help me with an expression to determine
this.

Sajit

Column function
 

=COLUMN(INDIRECT(F5))

where cell F5 has the text CZ108.



"Sajit" wrote:

I want to use the column function to determine the column number of a cell
reference at another cell location. That is to say, cell F5 has the value of
another reference CZ108. Can some one help me with an expression to determine
this.

Sajit

Column function
 

I want use minus function in text function.for e.g. 8:10 - 8:30 .can use it
this?

"Sajit" wrote:

I want to use the column function to determine the column number of a cell
reference at another cell location. That is to say, cell F5 has the value of
another reference CZ108. Can some one help me with an expression to determine
this.

Sajit

Column function
 

Thanks Vergel, exactly what I was looking for.

"Vergel Adriano" wrote:

=COLUMN(INDIRECT(F5))

where cell F5 has the text CZ108.



"Sajit" wrote:

I want to use the column function to determine the column number of a cell
reference at another cell location. That is to say, cell F5 has the value of
another reference CZ108. Can some one help me with an expression to determine
this.

Sajit