LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
CLR
 
Posts: n/a
Default

=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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
search more than one character Dolores Excel Worksheet Functions 2 May 19th 05 09:45 PM
How can I search for more than one text character in a cell? Dolores Excel Worksheet Functions 3 May 19th 05 09:44 PM
How do I search for more than one text character in one cell? Dolores Excel Worksheet Functions 0 May 19th 05 06:54 PM
Is it possible to search for the "?" character RagDyeR Excel Worksheet Functions 1 April 9th 05 08:46 PM
Search for a specific character in a cell in an if statement mcl Excel Worksheet Functions 2 January 4th 05 09:14 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"