FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,362
- Office Version
- 365
- 2016
- Platform
- Windows
I have this working part way, but of course, not complete. The original is in column A and I would like the results of column B. Column C shows the formula I tried.
bibles.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Colossians 4:18 | Colossians | Colossians | ||
2 | 1 Thessalonians 1:1 | 1 Thessalonians | |||
Sheet4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1:C2 | C1 | =LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1) |