Populate cell with letters from other cells

  • Thread starter Thread starter ERudy
  • Start date Start date
E

ERudy

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 |
+-------------------------------------------------------------------+
 
=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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Use COUNTIF across a range of cells with formulas 0
Cell Formula 2
cell reference 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
calculate average of populated cells 2
Need a lookup formula 3
Populate cell with data from another worksheet 4
Count if based on criteria within cells on another sheet 1

Back
Top