A little problem with space

[Dhruva101]

I have a very simple IF formula as follows.

=if(OR(A2="",A2=BLANK),A2,B2)

This formula is placed in C2.
This works good as long as A2 has some value other than space or blank.
when A2 has space, C2 should also has space, but it is populating with ZERO. I think the cell C2 has associated with such format.

What should I do to get spaces or blank on C2 cell ?

[Carim]

Hi,

Please Login or Register  to view this content.

HTH
Cheers
Carim

[Dhruva101]

A Sweet Solution... Thank you...

[Carim]

Glad I could help ...

Thanks for the feedback

Carim