Hello,

I am trying to figure out how to return multiple values that are adjacent to a series of the same substring. So here is the setup. Say in cell [A1] I have a very long string. Within this string, the following substring will occur an unknown number of times:

"@baseRate":"499.0"

This part, "@baseRate": will always be the same, but the "499.0" will vary (both the length of that string and the number of occurences of the string will vary). So I could have a string like this in [A1]:

....."@baseRate":"499.0"........."@baseRate":"399.0".........."@baseRate":"99.0" (the periods are other parts of the string that I am not concerned with)

What I would like to return in [B1]:[D1] would look like the following:

B1: 499.0 C1: 399.0 D1: 99.0

The problem I foresee is the actual rate data I am looking for will not have a fixed length and the "@baseRate" could occur one time or it could occur 30+ times.

Any help is very much appreciated.

Thank you,

learning_VBA