Oldsoftboss
AWF VIP
- Local time
- Tomorrow, 00:17
- Joined
- Oct 28, 2001
- Messages
- 2,504
I have an excel spreadsheet with text in one of the cells in the follow format:
Nrecs: 19
Nrecs: 192
Nrecs: 2219
Nrecs: 33319
Nrecs: Stands for the No of records (or rows) that contain data.
How do I strip the Nrecs: to leave just the number ?
I have tried all variants of the left and right functions without success.
Dave
Nrecs: 19
Nrecs: 192
Nrecs: 2219
Nrecs: 33319
Nrecs: Stands for the No of records (or rows) that contain data.
How do I strip the Nrecs: to leave just the number ?
I have tried all variants of the left and right functions without success.
Dave