Excel Problem



My problem is that i have a code no in 001 , 002 003 continue to 016
now i want to change the 001 to "Monti", 002 to "Nur" and 003 to "KG1"
and so on.

i want to type the number and the result shown me in text like Monti ,
Nursary and so on.
ClasCode Change into
000 Mont
001 Nur
002 KG 1
003 KG 2
004 I
005 II
006 III
007 IV
008 V
009 VI
010 VII
011 VIII
012 IX SCI
013 IX GN
014 X SCI
015 X GN
016 X COMP

Mike H



Wher C1 is the Code No and your table is in A1 - B17


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF, multiple criteria 5
Record output in queries 1
Help!! Error msg sending mail, wont send! 1
sumproduct with multiple tab ranges 10
Data Combination 1
Cycle ride 13
Text to XML 2
Emails can not be sent 1