I have separated a long list of addresses where the street number and street
name are all in one cell. Using FIND, LEFT/RIGHT, and REPLACE, I have now two
columns, the first with the street number and the second with the street name.
But I cannot sort because when I click on a cell, the formula is there, not
the actual data. How do I get the real data in the cell so I can sort?
--
Erik (a Word 2007 user)