Find Number within Text

[renjithpl]

hi......

I have to FIND only number within the text, from both fields below, and compare it and if it doesn't match then gives "error".

This is the formula I used in excel: =ISNUMBER(FIND(Sheet1!D2,Sheet1!C2))

I tried =If(Num(ResponCatCode)<>Num(ResponsiveCategories), 'Error')

But its not working properly

Is there any script I can use…

for example if responsiveCategories has "4-.... " and if ResponCatCode says "2-..." it should say error

ResponsiveCategories	ResponCatCode
4-Communication regarding Enron financial issues
2-Communication between Enron and its auditors - reference to such communications	2-Communication between Enron and its auditors - reference to such communications 4-Communication regarding Enron financial issues

[renjithpl]

Thanks i got what is vTest. And what number i should put in [write number here]. What do you mean by [write number here] ?

[justinasp]

In this place you should enter which number in a row you want to get: 1 - you'lll get the first digit in string vTest, 2 -second, ect.

I attach an example you can try to play with. Hope it will explain your issue.

Justinas

[renjithpl]

Hi Justinas,

your example helped me a lot in learning about strings. But i am quiet confused with my requirements. So Can you please attach me an example.

ABC and XYZ are both columns

ABC XYZ

4; 5 4; 5; 6; 7

Here first two strings are matching in both columns (4; 5 and 4; 5). But XYZ has more apart from 4; 5 (6; 7). If any thing more than ABC then it should give an Error.

Therefore it can be (2; 3 and more than 2; 3), (2; and more than 2; ) there are lot of probabilities. You can give me the example for the above table..

Thanks a lot Justinas.

You have been so good to me so far. it would be really greatful.

[justinasp]

I don't understant your issue this time.

However comparing two sequencies of digits sometimes it's enough to take sums of those rows (this case use the most primitive function SUM()).