Hi,

Me again

I have a text string in cell B3 with a name and all I want to do is extract the first letter after every space with a formula but not the title.

So for example:

Mr Davy Jones should return as DJ

I have the below formula that works to a point

=IFERROR(MID(B3,FIND(" ",B3)+1,1),"")&IFERROR(MID(B3,FIND(" ",B3,FIND(" ",B3,1)+1)+1,1),"")
But it doesn't work if I have a double barrel name such as Mr Davy Jones Smith and returns only DJ still and ideally it should return as DJS.

Any ideas?