VBA code - Convert one value to another value

**missy22** · 11-21-2012, 10:00 AM

Dear all,

I have the following values in column B:
CITG
WF
JPM

I would like to translate the codes into meaning names in column C such as:
(desired output)
CITG --> Citi
W F--> fargo
JPM --> jp.morgan

I am using the following code below, however the code below is not printing anything in the next column.

Please Login or Register  to view this content.

Any help would be very much appreciated.

Thank you for your time and help.

**thisisgerald** · 11-21-2012, 10:07 AM

@missy22

what's with this code of yours?

Please Login or Register  to view this content.

try this:

Please Login or Register  to view this content.

**kbkumar** · 11-21-2012, 10:13 AM

Hi Missy22,

Try this:

Please Login or Register  to view this content.

Hope this helps.

**missy22** · 11-21-2012, 12:18 PM

Dear all,

Thank you so much for your reply and help. I later figure out the same problem as user "thisisgerald " notified in the post. I apology's for posting such a simple and silly problem and wasting your time.

Nevertheless, I really appreciate your time and help (kbkumar & thisisgerald), for reading my problem and solving it. Thanks you all so much.

Have a great day.

Kind Regards
Missy