View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

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