I have a need to sort, a column, with cells that contain both
letters/characters and numbers. When the cell has a combination of
characters and numbers, I would like Excel to ignor any character that
is NOT a number and then sort the cells.
Example of data
6
[6
6]
[6]
7
12
14
14]
The above example 'shows' the resulting sort that I am looking for. I
need to keep the data displayed with the extra characters.
Any help out there?
Bookmarks