Hi... I'm trying to find a way to do a series of replacements (about 200 at the moment) in two separate strings - but I only want the replace to happen where there is an exact match.

For example, I want to replace "There is 1 line of text here" with "There is ONE line of text here"
But I want to ignore the "1" in "There are 104 lines of text here"

This is a small sample of the way I was doing it, but I'm sure there is a much better way

FinalStringA = Replace(StringA, "1 ", "ONE ")
FinalStringA = Replace(StringA, "2 ", "TWO ")
I've tried playing with a leading and trailing space in the value to find, but that isn't working correctly.

Any idea how to force a whole word match?

Thanks!