View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default TEXT (searching for a character)

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