Obtaining numbers out of a value string

[Moldo]

Hi,

I am trying to get some numbers out of a string of data that is external from the web so it will be continually updating.

For example I will have a value like this: (Number of Records: 3772). But when I refesh it the value could be (Number of Records: 384) so I need this to update with it.

I have been looking through the forum but could not find anything specific. I was hoping for a formula that could go between the space after the colon to the right perenthesis, would that be possible? Everything but the number is fixed.

Thanks!

 

[kpark91]

N/A.

Ignore what I asked, totally thought it was something related to the web for some odd reason..

 

[Smitty]

Welcome to the Board!

Try:

=MID(A1,FIND(":",A1)+2,LEN(A1)-FIND(":",A1)-2)

HTH,

 

[Moldo]

Welcome to the Board!

Try:

=MID(A1,FIND(":",A1)+2,LEN(A1)-FIND(":",A1)-2)

HTH,

That worked!! Thank you, my life is much simpler now!

I am going to be on here more often!