I have data from an external source that I put in an Excel worksheet.


These raw data contain results for the previous 12 months and are updated every month.
Those raw data also show the variables for the query. One cell contains the names of the selected months.
With a formula I can extract the text I want and put it in the column headercells as column names.
As I thereafter format the raw data as a table in Excel the column names are transformed to plain text.
Because the column headers change every month, I want tot keep the formulas so I can extract the names from the cell as mentioned above.

My question is:
Is there a way I can put a formula in the header of a table in Excel, or put the result of a formula in the column header cells?

Jacques