Prev: Reference to values disappear after closing file
Next: Showing the Differences
From: Pam on 26 Feb 2010 09:56
Hubisan,

I'm sorry, I should have known that. Thank you for the formula and info you
supplied. One more thing, can this be written so that I can use it in vba
code?

Thanks again,
Pam

"Hubisan" <hubisan(a)gmail.com> wrote in message
news:c8cfbbae-4704-4b39-9e11-64c9ca5268e1(a)g11g2000yqe.googlegroups.com...
> Ah, sorry for the mistake, using swiss german excel and we use ";"
> instead of ","
>
> Right( text, number_of_characters )
>
>> text is the string that you wish to extract from.
>
>> number_of_characters indicates the number of characters that you wish to
>> extract starting from the right-most character.
>
> and Russells formula would work as well, just add wildcards:
> =ISNUMBER(SEARCH("??P",H11))+G11=5
>
>


First  |  Prev  | 
Pages: 1 2 3
Prev: Reference to values disappear after closing file
Next: Showing the Differences