Replacing Character in Cell - Please Help

Giganews Newsgroups
Subject: Replacing Character in Cell - Please Help
Posted by:  James8309 (jaedong12…@gmail.com)
Date: Tue, 15 Jul 2008

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

Replies