Concatenate if there is a value or Find and Replace Null values

R

roco

I have 125 columns of data to concatenate into one cell. I would lik
the reult to be a succinct list of only the rows that contained values


Here is an extract of the concatenation:

=CONCATENATE("<li>",$CE1,": ",CE2,CHAR(10),
"<li>",$CF$1,": ",CF2,CHAR(10),
"<li>",$CG$1,": ",CG2,CHAR(10),
"<li>",$CH$1,": ",CH2,CHAR(10),
"<li>",$CI$1,": ",CI2,CHAR(10),
"<li>",$CJ$1,": ",CJ2,CHAR(10),
"<li>",$CK$1,": ",CK2,CHAR(10),
"<li>",$CL$1,": ",CL2,CHAR(10),
"<li>",$CM$1,": ",CM2,CHAR(10),
"<li>",$CN$1,": ",CN2,CHAR(10),
"<li>",$CO$1,": ",CO2,CHAR(10),
"<li>",$CP$1,": ",CP2)

This generates:
<li>function:
<li>housing:
<li>io_connection:
<li>item_fam:
<li>manufacturer: ITW Switches
<li>rohs: No
<li>itw_series: Series 23
<li>hole_diameter:
<li>input_voltage:
<li>mil_spec_no:
<li>operation:
<li>current:

Now I need to find and replace the blank values that this creates, a
only CI2, CJ2 and CK2 have values.

And this is the problem: the Find and Replace Dialogue does not behav
as I would expect after pasting all of the concatenated results a
values.

Replace:
<li>*: CHAR(10)

where * is the wildcard

With:

[blank]

And this just does not work. Any ideas would be appreciated
 
Top