New Contributor

# Changing a column of formulas to a column of values

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

# Re: Changing a column of formulas to a column of values

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

# Re: Changing a column of formulas to a column of values

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