I have 125 columns of data to concatenate into one cell. I would like 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:
<lifunction:
<lihousing:
<liio_connection:
<liitem_fam:
<limanufacturer: ITW Switches
<lirohs: No
<liitw_series: Series 23
<lihole_diameter:
<liinput_voltage:
<limil_spec_no:
<lioperation:
<licurrent:

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

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

Replace:
<li*: CHAR(10)

where * is the wildcard

With:

[blank]

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