trim function

[specter]

i am using a formula

in c1
if(a1="a","***","")

sometimes the formula fails in subsequent rows
i suspect that there is a blank space following the "a"

how would one incorporate the trim function within the if statement
or do you have to use a helper column to trim and then evaluate the
trimmed result

thanks

 

[Govind]

Hi,

Use

=if(trim(a1)="a","***","")

Regards

Govind.

 

[Guest]

if(trim(a1)="a","***",""). --Bruce

 

[specter]

On Thu, 29 Dec 2005 21:19:49 -0500, (e-mail address removed) wrote:

thank you
just couldn't get it through my hard head that it was easier than i
was making it

thanks again