I have a column with numbers and letters. I would like to add 21- in front of every one of them. I do not, how ever want to change every one manually as there are over 8000 entries. I would like to know if there is a Custom format that will do both number and letters.
Example: "21-"@ will change anything I have as a Letter to 21-ext....
Example: "21-"# will change anything I have as a number to 21-123.....
Is there a way to make it change 21- to both letters and numbers because I can only currently do one or the other.
Or maybe there is another way to make this happen not using this method. I just need everything in Column A to have a 21- in front of it.
Thanks a lot for any help and input.
P.s. I used the search and could not find something similar to this.
Example: "21-"@ will change anything I have as a Letter to 21-ext....
Example: "21-"# will change anything I have as a number to 21-123.....
Is there a way to make it change 21- to both letters and numbers because I can only currently do one or the other.
Or maybe there is another way to make this happen not using this method. I just need everything in Column A to have a 21- in front of it.
Thanks a lot for any help and input.
P.s. I used the search and could not find something similar to this.