Concatenate

Emily · Sep 26, 2003

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 · Sep 26, 2003

Emily,

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

Jill

Emily · Sep 26, 2003

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
.