Excel 2007 : split content of cell based on characters

Hi,

Anyone can help me with splitting the content based on characters.

For example, my cell A1 contains "B 60 BENPA @ 102.700000", that should be splitted in to:

Cell B1: B
Cell C1: 60
Cell D1: CEU
Cell E1: 102.700000

Counting number of characters doesn't work (except for the first one i.e. B )because the number can has more than 2 digits and the name can be 3,4, or 5 characters (i.e. it can be BGL instead of BENPA).

Thanks and hope anyone can help me,

Cheers,
TDO

Use Data>Text To Columns, delimited with delimiters of space and @