Is there anyway to do a find/replace that will replace the text if, and only if, the text being replaced is the complete string in the cell (i.e. exact match).
Example:
ColA in my worksheet may contain data as follows:
AI1234
AI123456
I want my VB routine to always replace AI1234 with "ID25" and I always want to replace AI123456 with "ID33" (simple enough). What i don't want is the "AI123456" to become "ID2556" when the command to replace AI1234 executes.
I'd like to do this using VB code.
Thanks!
Example:
ColA in my worksheet may contain data as follows:
AI1234
AI123456
I want my VB routine to always replace AI1234 with "ID25" and I always want to replace AI123456 with "ID33" (simple enough). What i don't want is the "AI123456" to become "ID2556" when the command to replace AI1234 executes.
I'd like to do this using VB code.
Thanks!