DATA TYPES and columns headers

The new DATA TYPES in Excel for Insiders (Beta at this point) are certainly good fun. But typing in the column title for the data you've extracted from each cell is a right pain.

If you wish to select a long list of items from the field selector, you would think that you would be doomed to have to look at each cell to see what has been selected and then type it into each cell above to act as a column header. Problems arise when you later change the cell reference but fail to update the header.

Instead, we can just use a formula to extract the relevant text from the data type formula. Notice that if the field selected is one word, the cell reference is in the form =D5.gravity whereas if the field selected has a space in it the cell reference is of the form =D5.[average radius], with the brackets. A formula can be put into the cell above and then copied rightways to cover however many cells you've extracted from the data type.

The one I have devised seems to be working. Please feel free to suggest improvements.

Here, cell D5 has been converted to Data Type | Space.