Hi guys!

If you generate a column of data from something else using a formula, this list is not available to copy to another location as the list is still linked to the original dataset that Excel worked on. How do I make a list generated by a function (in this case the LEFT function) copyable to another location so that it is not linked and changed by removal of the original data?