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