Concatenate

[Emily]

I'm trying to make a formula that will concatenate a range
of cells, but ignore cells that contain "0".

For example:

D12: SFT
E12: co2
F12: 0
G12: r2

CONCATENATE(D12,E12,F12,G12)= SFTco20r2
I need it to read = SFTco2r2

How do I create a formula that will ignore cells that
contain zeros?

Thanks!

 

[Jill]

Emily,

try:
=CONCATENATE(IF(D12=0,"",D12),IF(E12=0,"",E12),IF
(F12=0,"",F12),IF(G12=0,"",G12))

Jill

 

[Emily]

Thanks! It works great.

-----Original Message-----
Emily,

try:
=CONCATENATE(IF(D12=0,"",D12),IF(E12=0,"",E12),IF
(F12=0,"",F12),IF(G12=0,"",G12))

Jill
.