Left Right Left Right

[Oldsoftboss]

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

 

[Oldsoftboss]

Jumped too soon.....

myCell = Nrecs: 33319

myNumber = Right$(myCell, Len(myCell) - 6)

will strip the first 6 characters from the text.

Dave

 

[Guus2005]

Is this an attempt to crank up the number of posts you have?

The above statement is a joke. Sorry this is very off topic. I am sure i will be banned for this.