Populate cell with letters from other cells

What formula can I use to get the answer shown in cells G1:G4? Each row contains a set of cells with letters that must be combined into the G cell.
The right most cell will become the first letter of the work in the G cell and the other letters will be added to form a name. see attached example.

thanks for any help
Rudy

I wasn't able to download the pdf. Can you post the example ?

You must open the thread, then click on attachment

HTH
--
AP

"Dave O" <[email protected]> a écrit dans le message de news:
[email protected]...
>I wasn't able to download the pdf. Can you post the example ?
>

=OFFSET($A1,0,COUNTA($A1:$F1)-1)&IF(COUNTA($A1:F1)>1,$A1,"")&IF(COUNTA($A1:F1)>2,$B1,"")&IF(COUNTA($A1:$F1)>3,$C1,"")&IF(COUNTA($A1:$F1)>4,$D1,"")&IF(COUNTA($A1:$F1)>5,$E1,"")

HTH,
--
AP

"ERudy" <[email protected]> a écrit dans le
message de news: [email protected]...
>
> What formula can I use to get the answer shown in cells G1:G4? Each row
> contains a set of cells with letters that must be combined into the G
> cell.
> The right most cell will become the first letter of the work in the G
> cell and the other letters will be added to form a name. see attached
> example.
>
> thanks for any help
> Rudy
>
>
> +-------------------------------------------------------------------+
> |Filename: name test.pdf |
> |Download: http://www.excelforum.com/attachment.php?postid=4769 |
> +-------------------------------------------------------------------+
>
> --
> ERudy
> ------------------------------------------------------------------------
> ERudy's Profile:
> http://www.excelforum.com/member.php...o&userid=34365
> View this thread: http://www.excelforum.com/showthread...hreadid=542547
>