Hi all...
my first post..
i have a dilemma, i have data in the following ways which i wold like to sort by odd and even numerical value
i have a range from A1-01-1A to A9-10-4B
where only the middle digits of the data needs sorting to get even numbers and odd numbers..
what formula needs to be written to make the sort possible ?
Thank you
Bookmarks