search for a value within a string

[davisgodoy]

Will someone have the programming of how to have a variable in a list of values and when it looks for a value and finds it, it returns the following 5 letters? for example I have AABBCCCCCDDDEEEEEFF and if I search for BB, it returns CCCCC and if I search for DDD, it returns EEEEE and so on as a search function in Excel

 

[thisismyshine]

I believe that's in Text Manipulation?

 

[thisismyshine]

Did you find what you were looking for?

 

[Dm114]

Will someone have the programming of how to have a variable in a list of values and when it looks for a value and finds it, it returns the following 5 letters? for example I have AABBCCCCCDDDEEEEEFF and if I search for BB, it returns CCCCC and if I search for DDD, it returns EEEEE and so on as a search function in Excel

Try this
(?<=[lv=search_key])(\w{5})

 

[MacroDroidDev]

You can validate the above at https://regex101.com/ if you substitute [lv=search_key] with for example BB in regex101 you will see the next 5 chars returned.