Converting Formula Columns to Text in Excel for Avoiding Circular Arguments

·

Quick question, is there a way to quickly convert a formula column into just text? I.E. If I make several formula columns and then run new formula columns off of the results, then a final formula column to combine the data from those columns. Basically in excel the function would be to copy the column and past it over itself as plain text, to avoid circular arguments etc.

3 comments

· Sorted by Oldest

Joseph V.
·
·
https://app.clay.com/workspaces/211664/tables/t_VoD40ZuDQMGi/views/gv_JXecPyDzI7dt
Clay Team
APP
·
·
Hey there Joseph sorry for the delay, taking a look.
Clay Team
APP
·
·
So you can change the value of formulas by clicking the column header of the formula and selecting the first option that pops up. But they should be text columns by default.

Joseph V.
·
·
https://app.clay.com/workspaces/211664/tables/t_VoD40ZuDQMGi/views/gv_JXecPyDzI7dt
Clay Team
APP
·
·
Hey there Joseph sorry for the delay, taking a look.
Clay Team
APP
·
·
So you can change the value of formulas by clicking the column header of the formula and selecting the first option that pops up. But they should be text columns by default.