| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Character Search.
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 |
|
#2
|
|||
|
|||
|
=mid(b2,9,1) will get ninth charecter from cell b2 -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=382366 |
|
#3
|
|||
|
|||
|
=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 |
|
#4
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search more than one character | Excel Worksheet Functions | |||
| How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
| How do I search for more than one text character in one cell? | Excel Worksheet Functions | |||
| Is it possible to search for the "?" character | Excel Worksheet Functions | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
Linear Mode
