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

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" a écrit dans le message de news:
...
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($A 1:$F1)4,$D1,"")&IF(COUNTA($A1:$F1)5,$E1,"")

HTH,
--
AP

"ERudy" a écrit dans le
message de news: ...

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