Formula

[rttaksali]

Hi there,

I have a table column of first and the last name e.g.
A1 Rashi Gadia
A2 Monty Smart
A3 Ramy Daddy

I want to create a formula such that the in cell b1 is RG. i.e. I
want to capture the first character of the word.

Thanks for your help...

Bye

Rashi

 

[T. Valko]

Try this:

=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)