=mid(f2,9,1)
There are other string functions that you may like, too.
Look in Excel's help for =left(), =right()
brookdale wrote:
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
--
Dave Peterson