database decoding

[J]

Anyone have a solution for decoding a database?

I have a thousand microsoft excel entries with patient
information encoded into a string of numbers. For example,
one cell entry might be "0122143", where each digit in a
certain position indicates a type of infection, a site of
infection, or whether cultures were positive or not.

Anyone know how to get excel to "decode" this, and spit
out the above information in adjacent cells?

Help would be greatly appreciated!

-J

 

[Jim Gordon MVP]

Hi J,

Excel's help file has excellent examples for the worksheet functions called
MID()
LEFT()
RIGHT()
IF()

You need to make a conditional statement something like
IF(LEFT(A1,1)="0","Infection","Not Infected")

-Jim