Hi,
I’m looking for an Excel function (not a VBA) which returns the position of the 3rd and 4th time a specific character appears in a text string – for example @

Example text string in cell A1:
what@time@is@it@right@now

In the text string above – the position of the 3rd and 4th time the @ is displayed is position 13 and position 16

I have tried to use the =FIND() function – but the problem is that I then have to refer back to the 'previous' cell to find the ‘start_num’ and I would like to have the columns independent of each other.

Thanks,
Sven