Find and replace with exact string

I need to find an exact string (i.e. "Room 1,2,3,4") in a sheet and replace it with another exact string (i.e. "Room 1, Room 2, Room 3, Room 4") in the same sheet.

How do I denote an exact string?

The problem I am having is:
find "Room 1,2,3", replace with "Room 1, Room 2, Room 3" and find "Room 1,2" and replace with "Room 1, Room 2" in the same sheet is finding "Room 1,2" within "Room 1,2,3" and replacing it with "Room 1, Room 2,3".

How could I make a more general find and replace that deals with all of these possible combinations?
How do I denote an EXACT string in VBA?

What code are you currently using to find and replace?

Hi,

If the cells contain just that information, and you are able to select these cells only as your range, can you not simply do a Find and Replace with:

Find what: ,
Replace with: , Room

Regards

Hi and welcome to the forum

This is not VBA, and is a bit messy, but you could put this in a helper column, copied down...
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,",2",", Room 2"),",3",", Room 3"),",4",", Room 4")

Then if you want, copy/paste values over the original data andthen delete the helper

This is my current code:

Please Login or Register  to view this content.

If the order if reversed, the macro finds "Ws; Rooms 1,2" in "Ws; Rooms 1,2,3" and changes it to "Meeting Room 1 | Meeting Room 2,3"

How can I denote the exact string, nothing more, nothing less.

Thank you all!

Moderators note: code tags added for you - this time

carrie....Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

One method:

Please Login or Register  to view this content.