Sorting text

T

Tim

This is not impossible!

First, insert a column to the left (column A)
in A1 enter the equation =mid(b1,1,3)
copy the equation for all records and sort by column A.
The records which start with a desired character will be
grouped.

For the records which returned a "bad" character, change
the equation to =mid(b1,2,3) and resort by column A.
Repeate the process until you have filtered past all
the "bad" characters.

Good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top