How to Combine Text While Preserving Superscript Formatting in Excel
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.

- 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 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.
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.
Click on the cell where you want the combined and filtered results to appear.
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), "")
Press Enter to execute. The formula will return an array of combined text from the specified columns where your designated conditions are met.

Use a VBA Macro to Preserve Superscript Formatting
Since formulas cannot carry over formatting, you can use a VBA macro to combine cells while identifying and applying superscript formats character by character.
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. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the Software: Run the installation file and follow the on-screen prompts to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and instantly open your existing Excel files while preserving your complex data formulas and layouts.

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.




