Hi,
you can use the following function
=MID(a7,4,1)

regards,
julian

F. Lawrence Kulchar wrote:
Within cells, I have TEXT strings, such as:

A

1 abcde
2 fhjuy
3 RTgfT67%ty
4 mnl;;;opo
5 ,,, fhg'

QUESTION: 1) How can I search for the, e.g. 4th character within each cell;

and,...2) how can I search for the 3rd, 4th, and 5th characters?

Answer 1) d, u, f, ;, " "

2) cde, juy, gfT, l;;, ," "" "

Pls. advise.

thank you,

flkulchar