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 - 29 Nov 2007 05:59 GMT
Try this:
=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)

Signature
Biff
Microsoft Excel MVP
> Hi there,
>
[quoted text clipped - 11 lines]
>
> Rashi