Is it possible to do an alphabetical sort while ignoring preceeding numbers
and symbols? That is, sort based on the first letters in a string of
characters.
Is it possible to do an alphabetical sort while ignoring preceeding numbers
and symbols? That is, sort based on the first letters in a string of
characters.
On Sat, 1 Oct 2005 16:10:02 -0700, "silver fox" <silver
[email protected]> wrote:
>Is it possible to do an alphabetical sort while ignoring preceeding numbers
>and symbols? That is, sort based on the first letters in a string of
>characters.
You can use a "helper column". In an adjacent column, insert a formula similar
to =LEFT(A1,2). Then select both columns and sort on the helper column.
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks