在要输入公式的单元格区域进行合并操作，

输入如下公式：

=＂截止＂&TEXT(TODAY(),＂M月D日＂）&＂各分支机构市场占有率同比平均＂&TEXT(B16,＂0.0%＂)&＂，高于平均：＂&A1&TEXT(B1,＂0.0%＂)&＂,＂&A2&TEXT(B2,＂0.0%＂)&＂,＂&A3&TEXT(B3,＂0.0%＂)&＂,＂&A4&TEXT(B4,＂0.0%＂)&＂,＂&A5&TEXT(B5,＂0.0%＂)&＂，低于平均：＂&A6&TEXT(B6,＂0.0%＂)&＂,＂&A7&TEXT(B7,＂0.0%＂)&＂,＂&A8&TEXT(B8,＂0.0%＂)&＂,＂&A9&TEXT(B9,＂0.0%＂)&＂,＂&A10&TEXT(B10,＂0.0%＂)&＂,＂&A11&TEXT(B11,＂0.0%＂)&＂,＂&A12&TEXT(B12,＂0.0%＂)&＂,＂&A13&TEXT(B13,＂0.0%＂)&＂,＂&A14&TEXT(B14,＂0.0%＂)&＂,＂&A15&TEXT(B15,＂0.0%＂)&＂.＂

再设置单元格式---对齐---自动换行

如果日期是当前日期的前一日的，公式改成如下

=＂截止＂&TEXT(TODAY()-1,＂M月D日＂）&＂各分支机构市场占有率同比平均＂&TEXT(B16,＂0.0%＂)&＂，高于平均：＂&A1&TEXT(B1,＂0.0%＂)&＂,＂&A2&TEXT(B2,＂0.0%＂)&＂,＂&A3&TEXT(B3,＂0.0%＂)&＂,＂&A4&TEXT(B4,＂0.0%＂)&＂,＂&A5&TEXT(B5,＂0.0%＂)&＂，低于平均：＂&A6&TEXT(B6,＂0.0%＂)&＂,＂&A7&TEXT(B7,＂0.0%＂)&＂,＂&A8&TEXT(B8,＂0.0%＂)&＂,＂&A9&TEXT(B9,＂0.0%＂)&＂,＂&A10&TEXT(B10,＂0.0%＂)&＂,＂&A11&TEXT(B11,＂0.0%＂)&＂,＂&A12&TEXT(B12,＂0.0%＂)&＂,＂&A13&TEXT(B13,＂0.0%＂)&＂,＂&A14&TEXT(B14,＂0.0%＂)&＂,＂&A15&TEXT(B15,＂0.0%＂)&＂.＂