Search a String - Please Help?!?!

[charlie79]

I have a cell that contains a string, part of which I want to do a test on. Something like this "Next Grade 178359". I want to check the 6 digit number, not the text. I know this can be done in VBA, I just can't think this morning. Please help...
This message was edited by charlie79 on 2002-03-12 06:03

 

[Barrie Davidson]

On 2002-03-12 05:51, charlie79 wrote:
I have a cell that contains a string, part of which I want to do a test on. Something like this "Next Grade 178359". I want to check the 6 digit number, not the text. I know this can be done in VBA, I just can't think this morning. Please help...
This message was edited by charlie79 on 2002-03-12 06:03

Assuming it's always the last six digits,

=RIGHT(A1,6)

Regards,