Hi, i got a question from your side, the question is how can i find a special character with conditions like (after any character or before any character). I got some data also see the image below:-

 

Follow this simple steps.

STEP-1. we have to find something common(in array) and unique(in cell) here that value is "@" 

 

STEP-2. Find our required character, here that is "."(dot)

as per the image above, put the previous find function`s value as [start_num].

Step-3. finalizing the formula