Formatting numbers.

Hi, Im using text to columns to gather data.
This data is a Hexadecimal value and is spaced as such 05 F1 00
I need to format this sequence of numbers/text with no spaces to convert to decimal. ( I'm using formula HEX2DEC)
Help !
I tried several number formats with no success.

Thanks
Gerry

=hex2dec(substitute(a1," ",""))

Thanks, I'll try that when I get a chance
Gerry