OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP!
Hi,
Somewhat of a pain:
=CONCATENATE(IF(I15="","",I15),IF(I15="","",CHAR(1 0)),IF(J15="","",J15),IF(J15="","",CHAR(10)),IF(K1 5="","",K15),IF(K15="","",CHAR(10)),IF(L15="","",L 15),IF(L15="","",CHAR(10)),IF(M15="","",M15),IF(M1 5="","",CHAR(10)),IF(N15="","",N15),IF(N15="","",C HAR(10)),IF(O15="","",O15))
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"AfricanTigress" wrote:
The formula below works but I would like to omit lines that are blank.
i.e.
=CONCATENATE(I15,CHAR(10),J15,CHAR(10),K15,CHAR(10 ),L15,CHAR(10),M15,CHAR(10),N15,CHAR(10),O15)
Say line K15, L15 and M15 had no data like this :
I 227 Finney Lane
J Heald Green
K
L
M
N Cheadle
O SK8 3QB
How can I tell it to omit the blank lines, K,L,M so the address is without
blanks?
Your help would be much appreciated.
Thanx
|