I need to find a quick way to delete or move all letter data from a range of
cells while leaving the number data intact. I need to be able to sort my
spreadsheet by the numbers in each cell, not by the letters. I could go
through each cell and delete the letters manually, but I'm working with
almost 2000 cells and that would be a complete waste of time. The cells I'm
working with look like this "ABC 123" and I need them to look like this "123"
or this "123 ABC".
Any help would be greatly appreciated.