Replacing Character in Cell - Please Help

  • Thread starter Thread starter James8309
  • Start date Start date
J

James8309

Hi Everyone,

I am trying to replace certain characters in a cell using Ctrl + F ->
Replace but I think I am doing something wrong. Can anyone help?

1. I have Number(1 to 13) & Alaphabet combined code looking like
thingy from A1:AM65536. Yes there are alot of them.
e.g. 1D2D4C13H12C etc

2. I am just trying to replace 13 with "K", 12 with "Q" 11 with "J"
and 1 with "A".

3. How do I replace those?

thank you
 
If you do "Edit & Replace" 4 times, starting with 13 first, then working
down, I don't see any problem.

That is, unless you might have 114 in the mix.
Then you must decide if it's 2 1's, or an 11 and a 4.

Exactly what problems are you experiencing?
 
Back
Top