Subscribe Bookmark RSS Feed

How do I remove a column formula but retain the values (without scripting)

mikedriscoll

Community Trekker

Joined:

Jun 23, 2011

Hi, How do I remove a column formula but retain the values (without scripting)? I remember seeing an answer to this several months ago, maybe at the JMP summit, but I've forgotten and can't seem to figure it out.

Thanks,

Mike

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Just remove the Formula column property. Values will be retained (as I remember it...).

Right-click on the column header and pick Column Info. There should be a list of properties. Select Formula and click the remove button.

2 REPLIES
Solution

Just remove the Formula column property. Values will be retained (as I remember it...).

Right-click on the column header and pick Column Info. There should be a list of properties. Select Formula and click the remove button.

mikedriscoll

Community Trekker

Joined:

Jun 23, 2011

Thanks. That worked.  I knew it was something simple, but couldn't remember it.