Changing a column of formulas to a column of values

Copper Contributor

I am trying to convert a column of formulas to a column of values created by the formula.  Not interested in F9'ng each cell.

 

Thanks,

 

Joe

2 Replies

Hi @Joe_Hurt ,

I think TRANSPOSE can be interesting.

TRANSPOSE function - Office Support
https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027

Kind regards

Hans

Thanks Hans. I just figured it out. Copy the fields and post as numbers.