Function Problems

How to Keep Excel Formula Results Dynamic and Copy as Text

Natalie Taylor Sep 25, 2026 871 views

Question details

The user wants to preserve dynamic Excel formula results while displaying or easily copying the output as text in another cell, avoiding the need to manually paste static values.

How to Keep Excel Formula Results Dynamic and Copy as Text

Product: Excel
Device & OS: not provided
Scenario: Automating the display and extraction of dynamic formula outputs as copyable text in a separate cell.
Observed behavior: Currently, users must manually copy and 'paste as values' to get static text, which breaks the dynamic, automatically updating nature of the formula result.

Before you start

Before attempting to automate text extraction using macros, ensure your workbook is saved as a Macro-Enabled Workbook (.xlsm) and that you have backed up any sensitive data.

Solution 1Recommended

Use Cell References and Text Functions

The simplest way to keep formula results dynamic is to use native Excel functions like CONCAT or TEXTJOIN to reference the original cell and output text.

Select the Destination Cell

Click on the empty cell where you want the dynamic text to appear.

Link the Formula Cell

Type '=' and click on the cell containing your original dynamic formula (e.g., '=A1') to mirror the result exactly.

Combine with Text Functions

If you need the result formatted strictly as text or combined with other words, use a text function. For example, type '=CONCAT(A1, " additional text")' or use the TEXT() function to lock in specific formatting.

Solution 2

Automate Text Copying with a VBA Macro

Use a VBA macro with the Worksheet_Change event to automatically paste the text value of a formula result into a different cell whenever the sheet updates.

Seamless Spreadsheet Management

Easily Manage Dynamic Formulas with WPS Spreadsheet

WPS Office Spreadsheet fully supports dynamic arrays, advanced text functions like TEXTJOIN, and VBA macros, allowing you to effortlessly manage formula results and text manipulation.

1. Open Your Workbook: Launch WPS Office and open your existing spreadsheet containing the dynamic formulas.
2. Apply Text Functions: Use functions like TEXTJOIN or CONCAT directly in WPS Spreadsheet to reference your dynamic formula cell and output it as text.
3. Enable Macros for Automation: If you require VBA, navigate to the Developer tab, open the VBA Editor, and easily insert your Worksheet_Change event code just as you would in Excel.

Fully compatible with Microsoft Excel formulas and functionsRobust support for VBA macros to automate complex workflowsLightweight, fast, and free to use for everyday spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does copying a formula result manually change the output?

Standard copy-pasting copies the underlying formula itself, not the dynamic result. When pasted into a new location, relative cell references shift, causing the output to change unless you specifically use the 'Paste as Values' option.

Can I use VBA to copy text without losing the original formula?

Yes. By using the Worksheet_Change event in VBA, you can instruct Excel to automatically push only the calculated value of a formula cell into an entirely independent text cell. This leaves your original formula perfectly intact.

Are functions like TEXTJOIN and CONCAT available in all versions?

TEXTJOIN and CONCAT are available in newer spreadsheet versions like Excel 2019, Microsoft 365, and WPS Office. For older versions, you can achieve similar results using the CONCATENATE function or the ampersand (&) operator.

Excel & Data Problems