Hello again guys & gals
I have several loan code for example 1,2,3,4,5,6,7,8,9,10,11,12 and so on.
First five code translate as "consumer" (1,2,3,4,5) and 6,7 may be translate
as "commercial", 8,9,10 may be "residential" and so on.
I just have loan codes coming to me in one coulmn and they are in thousands.
So far, I am going line by line and write the loan category according to it
numric number.Is there any formula that I can apply and dgar it down to get
the text value according to the loan code?
Help will be appreciated
Fam
--
Message posted via http://www.officekb.com
Bookmarks