How to lookup values between a delimiter and replace based on range?

My pleasure. My amendment above should obviate the need for you to input any dummy data. I had just assumed (wrongly) that there were no blanks.