agraham216
New Member
- Joined
- Mar 24, 2002
- Messages
- 15
I have a text file I want to import into Excel. One of the data sets has a code for the actual data (i.e., A for apple, B for bananna, C for Grapefruit, D for Pineapple, .... U for whatever).
Is there an easy formula to covert the A, B, C, etc to the actual data value? The only way I know how to do so is:
If (A2="A","Apple",if(A2="B","Bananna"))
This will be rather cumbersome for letters A through U!!
Thanks
Is there an easy formula to covert the A, B, C, etc to the actual data value? The only way I know how to do so is:
If (A2="A","Apple",if(A2="B","Bananna"))
This will be rather cumbersome for letters A through U!!
Thanks