Formatting Issues

How to Combine Text While Preserving Superscript Formatting in Excel

Emma BrownEmma Brown Nov 11, 2026 869 views

Question details

The user wants to combine text columns in Excel and filter records based on specific criteria while keeping the original superscript formatting intact.

How to Combine Text While Preserving Superscript Formatting in Excel
Product
Excel
Device & OS
not provided
Scenario
Combining multiple data columns and filtering records to prepare results for a presentation while attempting to maintain rich-text cell formats.
Observed behavior
Standard Excel formulas successfully combine the text values and filter the data, but strip away rich-text formatting, causing superscripts from the referenced cells to convert to plain text.
Before you start

Before proceeding, note that standard spreadsheet formulas extract only the raw value from a cell. They cannot carry over rich-text formatting like bold, italic, or superscripts. Alternative methods like VBA are required if preserving the exact formatting is strictly necessary.

Solution 1Recommended

Combine and Filter Text Using the FILTER Formula

Use the FILTER function combined with the ampersand (&) operator to merge text from multiple columns based on specified criteria.

This method will correctly combine the text strings and filter rows matching multiple criteria simultaneously. However, because formulas only pull underlying data values, any superscript formatting from the original cells will be converted to plain text in the final output.

1
Select the Destination Cell

Click on the cell where you want the combined and filtered results to appear.

2
Enter the FILTER Formula

Type the FILTER function combined with concatenation. For example: =FILTER(Clean!$D$2:$D$1000 & " " & Clean!$F$2:$F$1000 & " " & Clean!$E$2:$E$1000, (Clean!$A$2:$A$1000=A2)*(Clean!$B$2:$B$1000=B2)*(Clean!$C$2:$C$1000=C2), "")

3
Execute the Formula

Press Enter to execute. The formula will return an array of combined text from the specified columns where your designated conditions are met.

Combine and Filter Text Using the FILTER Formula
Limitation on Formatting: Formulas cannot inherit cell formats. If you need the text to remain superscripted for PowerPoint, you must re-apply the formatting manually to the output or use a VBA macro.
Free Microsoft Office alternative

Process Data Easily with WPS Spreadsheet

While preserving superscript formats in formulas is a universal limitation across all major spreadsheet software, WPS Office provides a lightweight, free alternative to Microsoft Office. It offers robust data filtering, seamless formatting options, and VBA support to help you prepare your data for presentations effortlessly.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
  2. 2. Install the Software: Run the installation file and follow the on-screen prompts to set up WPS Office on your device.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and instantly open your existing Excel files while preserving your complex data formulas and layouts.
Fully compatible with Microsoft Excel formats (.xlsx, .xlsm, .csv)Supports advanced VBA macros to solve complex formatting limitationsFree and lightweight alternative to Microsoft OfficeFamiliar user interface for seamless migration without a learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does my text lose superscript formatting when combined using the CONCATENATE function?

In spreadsheet applications like Excel, functions only extract the underlying data value of a referenced cell. They do not read or carry over rich-text attributes such as font color, bold, italics, or superscripting.

Is there any built-in Excel function that keeps original text formatting?

No, there are no built-in Excel formulas (including FILTER, CONCAT, or TEXTJOIN) that can preserve the font formatting of referenced cells. You must rely on VBA macros or manual copy-pasting to retain these rich-text formats.

How can I copy formatting along with the combined text into a PowerPoint slide?

Instead of linking formula results, you can manually copy the originally formatted text cells in Excel and paste them into PowerPoint using the 'Keep Source Formatting' paste option. Alternatively, use a VBA script in Excel to build the formatted string before transferring.