software

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: www.excelforum.com/attachment.php?postid=4769 |
-------------------------------------------------------------------

--
ERudy
------------------------------------------------------------------------
ERudy's Profile: www.excelforum.com/member.php...oamp;userid=34365
View this thread: www.excelforum.com/showthread...hreadid=542547I wasn't able to download the pdf. Can you post the example ?You must open the thread, then click on attachment

HTH
--
AP

quot;Dave Oquot; gt; a écrit dans le message de news:
...
gt;I wasn't able to download the pdf. Can you post the example ?
gt;
=OFFSET($A1,0,COUNTA($A1:$F1)-1)amp;IF(COUNTA($A1:F1)gt;1,$A1,quot;quot;)amp;IF(COUNTA($A1:F1)gt;2 ,$B1,quot;quot;)amp;IF(COUNTA($A1:$F1)gt;3,$C1,quot;quot;)amp;IF(COUNTA($A 1:$F1)gt;4,$D1,quot;quot;)amp;IF(COUNTA($A1:$F1)gt;5,$E1,quot;quot;)

HTH,
--
AP

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