Maybe I should have included this code. Spaces can be highlighted, I'm just not sure if I run through the field once then run through it again with another replace formula.
Looks like you need to search for the spaces to do the replace, did you try using the instr function to look for "^^^" in the text you are trying to highlight (^ indicates a space)?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.