Find whole number and replace with text

[MKEXL]

I have 9 cells of numbers from 1 to 45. None of the numbers are the same. I want to replace each unique number with a unique name(text). I tried find and replace for #1 but Excel changed 1,11,12,13 etc. anything containing a 1.
Does anyone have any ideas as how I could accomplish this task??

2-4-19-36-44

1-17-28-31-45

5-23-25-33-40

20-26-29-32-43

9-18-22-30-37

11-21-38-39-41

6-13-34-35-42

7-14-15-24-27

3-8-10-12-16

 

[Fluff]

I tried find and replace for #1 but Excel changed 1,11,12,13 etc. anything containing a 1.

You would need to do the largest number 1st & work backwards.

 

[MKEXL]

You would need to do the largest number 1st & work backwards.

That is almost like doing this task manually. Is there some formula or lookup that I can use??

 

[Fluff]

Because you said

I tried find and replace

I thought you were doing it manually.
You could do it with VBA, but a formula would be a bit long.

 

[Fluff]

Is VBA an option for you?

 

[MKEXL]

Is VBA an option for you?

I figured out a way to fix my issue. I took the groups of 5 numbers and converted them to using text to columns. I then used Vlookup to substitute names for the numbers. Thanks for trying to help me!!

 

[Fluff]

Glad you sorted it & thanks for the feedback.