I have a spreadsheet that has numbers and number/letter combinations that I
am trying to reformat to text so it will sort like a text sort versus a
number. I have tried refromatting all cells to text but it still does not
sort correctly. Is there a way to copy to contents of the cell to another
location and change the formatting to text?