Hello. I would like to use Regex to replace all occurrences of "And" or "and" with "&" when used between two names in the first name field.
When I use a simple solution, it also replaces any string of "and" ... for example: Landon would be replaced with L&on
Is there a way to have it look for "space and space" so it will not replace any string of and? I'm sure this is easy but I'm stumped.
Please send me the solution and thanks.