Inital of surname needs extracting

[drazen]

Hi, I'm sure this is simple, but its got me.

I am wanting to extract the Surname initial from a string "Client Name"
However the format of the name changes, it could be

Mr John Doe
Mr Doe
Mr John Smith Doe

I need it to work from right to left, then extract the 'D'
can anyone help please?

Thanks
Tony.

 

[Gasman]

Use InstrRev and Left functions

 

[Minty]

A quick google will get you to https://access-programmers.co.uk/forums/showthread.php?t=60083