Please advice correct formula to know the position or the occurrence of a specific character within an excel cell.
For example in the cell contents "Oh why? Is there any hope? Please, oh Please, Thanx!
" (see pix below), we want to find the position of the 4th character "e". It should be in the 41th position.
The formulas working with are:
The first works if we want to find the 2nd or 3rd occurrence of "e", but the 4th, 5th, etc., doesn't work.
(also if we want to find "?" or "," or ".", or "!" also doesn't return the correct position)
Please advice on the correct formula to find within a text cell any position of any character.
Thank you in advance.