Return Characters to the right of space

Hi All,



I've read a number of threads but still can't get this right.



I want to return the characters to the right of the space but I'm getting back rubbish.



This is the type of data in the field AccountName



Z-Yachting Barcos y Apartamentos S.L 031

Zusi Ltd ST5

Leaders BR3



And this is the result I want



031

ST5

BR3



What I'm getting is:



os S.L 031

ST5

ers BR3



This is my current formula. Can you help?



Right([AccountName],InStr(1,[AccountName]," ")-1)





thank you



Anthony

Return Characters to the right of space