I am trying to extract the a set of 9 characters that follow the text “VRID”. There are a few variations on the text I am trying to extract.

I am trying to extract the a set of 9 characters that follow the text “VRID”. There are a few variations on the text I am trying to extract.

I’m not sure if the title makes sense, but here is what I am looking for:

I’m not sure if the title makes sense, but here is what I am looking for:

I’m not sure if the title makes sense, but here is what I am looking for:

Below is an excel formula that tracks bad behavaior for a game I play and manage a guild in, while having a built in forgiveness system. Column B should cound the total of strikes. The formula should reset its count and ONLY show the sum that is to the right of the most recent set of 10 consecutive 0s. It should also not count blank spaces, but still include the columns that are blank, once they are filled