Best Online Learning Platform and Collect Information

Find a special character with conditioins like (after any character or before any character)

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:-

data1

 

Follow this simple steps.

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

step1 


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

capture



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

Step-3. finalizing the formula


step3












Thanks in Advance.
Click here to download Exercise file. for further please contact.
Share:

No comments:

Post a Comment

Follow by Email

Popular Posts