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
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