I need to sort a column of alphanumic numbers in EXCEL with it ignoring the
prefix letters.
I need to sort a column of alphanumic numbers in EXCEL with it ignoring the
prefix letters.
Create a new column and extract the digits from the other cell. Then sort by
that column.
If your data looks like:
XX####
(always two alphas followed by the numbers)
it might be as simple as:
=--mid(A1,3,255)
Other formulas would depend on what your data looks like. You may want to post
a representative sample.
beasleyb wrote:
>
> I need to sort a column of alphanumic numbers in EXCEL with it ignoring the
> prefix letters.
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks