Find and Replace Many from Many

[seattlecajun]

This is killing me! Ok, so not really. I searched this and other forums and haven't quite found the solution that works yet. I tried Kutools and almost got it, but the find/replace feature there didn't account for 44 not being the same as 444, etc and as soon as it hit the first 44, it replaced it with the value for 44 instead of the value for 444. I hope I'm explaining this clearly.

Anyway, the issue, I have a large spreadsheet with values contained as such:

CategoryID's
511
101;56;482;529;584;511;79
465;181;261;451;479;526;106;455;60;516
465;181;261;479;526;455;516;106;60
...and so on down the line...

I've got another sheet with the values that I need to associate with those ID's

Id's Name
55 Apparel
56 Apparel/Kids
57 Apparel/Krav Maga
58 Boxing/Boxing Gloves
...and so on down the line...

I'm looking for a way to find and replace instances of say "55" with Apparel. Some items have multiple ID's associated so, I'd need them to look like "Apparel/Kids; Apparel/Krav Maga; Boxing/Boxing Gloves" instead of "56;57;58" like they do now.

I can't find a way to upload screenshots or sample files to help, if you know a way, let me know and I'll do that.

Thanks, any advice is much appreciated and would save me hours and hours of work.

 

[seattlecajun]

Forget the you're/your error. I'd like to blame it on autocorrect but.... lol

 

[Peter_SSs]

As always, you're suggestions worked perfectly! Thanks again, you're amazing. Your help is truly appreciated!

You are very welcome. And yes, we'll ignore the punctuation error.