Extracting letters from names

Hello,


I am trying to devise a formula to extract the first character of someones first name and the first two characters from their surname.

For example, if the name in any given cell was "Matthew Rogers" I would like to extract "MRO" from that.

I have tried several different formaulas but so far have been unable to crack it.

Any help you guys can offer would be appreciated.

Thanks
Chris

Ok im not the best with formulas but give this a go!

Assuming the name is in C10

=LEFT(C10,1) & MID(C10,SEARCH(" ",C10,1)+1,2)

or if you want it all in capitals:

=UPPER(LEFT(C10,1) & MID(C10,SEARCH(" ",C10,1)+1,2))

Thank you

That works well