Converting formulas from cell references to numbers

ArviLaanemets · #1 07-19-2022, 08:40 PM

On fly!

Leave the column with sum as it is. Add an empty column next to it, with formula like

Code:

= "" & Q6 & "+" & R6 & "+" & S6 & "+" & T6 & "+" & U6

NB! The added column displays all components of sum as string! You can take it as comment of formula.

And in case the components of original sum are formulas instead cell references, like:

Code:

= SUM(Formula1,Formula2,Formula3,Formula4)

in added column you use formula:

Code:

= "" & Formula1 & "+" & Formula2 & "+" & Formula3 & "+" & Formula3 & "+" & Formula4

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA or Formulas to parse out numbers based on criteria	durwood	Excel Programming	2	09-17-2019 06:59 PM
Rounding numbers in formulas	Lamont	Excel	3	01-09-2019 08:19 AM
Converting xls(x) with formulas to pdf	rheaney	Excel	2	11-22-2016 03:30 PM
Fields and References Don't Show as Numbers	peytontodd	Word	2	05-31-2014 07:05 PM
Cell formulas & formatting	kungfauxn00b	Word Tables	3	04-05-2011 04:54 AM