I don't know how you want to display the results, but using =MID(A1,x,1)
where x is 1 to 32 will return the value of that bit. You can ite this in
with an IF statement to give something like
=IF(MID(A1,x,1)=1,"Alarm","Noalarm"). Note that this counts from the left,
so changing x to 1 will return the MSB.

--
Ian
--
"MadManInABox" wrote in message
...
Here's my situation, I need to be able to get this sort of response:

I have a 32 bit binary word, each bit corresponds to a certain alarm. So
if
a certain bit in the word is 1 then that alarm is flagged, however if
several
bits are 1 then all the corresponding alarms are flagged.

Is there some way to use some sort of lookup table which will show which
alarms have been triggered?