=MID(B1,C1,1) will return whatever number of character is in C1.........if
9, then the 9th character from the left.

Vaya con Dios,
Chuck, CABGx3


"brookdale" wrote
in message ...

I am new to working with excel functions, and I have what is probably a
simple question, but I can't seem to find the answer.

Say in cell F2 I have:

TBA TBA T 9:30AM

The "T" after the second TBA is considered the 9th character? How could
I make an equation in one cell that would yield the 9th character in
another cell?

Thanks.


--
brookdale
------------------------------------------------------------------------
brookdale's Profile:
http://www.excelforum.com/member.php...o&userid=24617
View this thread: http://www.excelforum.com/showthread...hreadid=382366