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(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

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

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