Character Search.

[brookdale]

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.

[anilsolipuram]

=mid(b2,9,1)

will get ninth charecter from cell b2

[Dave Peterson]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[Dave Peterson]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[Dave Peterson]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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]

=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

[CLR]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>