3. St. Anacletus (Cletus) (76-88) (total line is a single cell)
4. St. Clement I (88-97)
5. St. Evaristus (97-105)
I want to eliminate [3. St.] ..
Assuming data above is in A1 down, another way to try is to put in B1:
=MID(TRIM(SUBSTITUTE(A1,"St.","")),SEARCH(".",TRIM (SUBSTITUTE(A1,"St.","")))
+2,99)
Copy B1 down, then do a copy paste special values to overwrite col A,
and delete col B. Then do the Data Sort on col A
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|