Return Characters to the right of space

[PanzerAttack]

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

 

[stopher]

Try:
Mid([AccountName],InStrRev([AccountName]," "))

 

[PanzerAttack]

InStrRev

Exactly what I needed, works perfectly.

thank you stopher

Anthony