Find the zero(s) and remove from a concatenation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using XL2000

I have a range A1:E:1 in worksheet1 containing numerical values.
I need to concatenate this range into cell F1 but exclude the cell(s) where
a zero may appear.

Solution needs to function through 50 rows.

Any programatic ideas appreciated.

Thanks, Paul
 
In F1
=if(A1=0,"",A1)&if(B1=0,"",B1)&if(C1=0,"",C1)&if(D1=0,"",D1)&if(E1=0,"",E1)

then drag fill down the column
 
You must log in or register to reply here.

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

Concatenate many cells without zero's 9
Concatenate 4
Concatenate a Range of Cells 4
concatenate from one cell to another 2
The syntax for programmatically inserting a "/" in the middle of a concatenated cell 7
Concatenate a row that is selected and include blank cells 11
Macro - searches for key word in a column and concatenates entire 6
Concatenating a zero 6

Back
Top