colums string

[kamakshi]

the column a has string = "final cont"
if cells(1,"a").text = " final cont"
but it does not recognize the final cont
should i cosider space also
hwo do i put it.

[westconn1]

yes
" final cont" is not = "final cont"

you can use trim function to remove leading and trailing spaces
trim(" final cont") is = "final cont"

[kamakshi]

if cells(1,"a").text = trim(" final cont") is not taking as final cont

[Siddharth Rout]

Try this...

If Ucase(Trim(Range("A1").Value)) = "FINAL CONT" then

If this doesn't work then I need to see your workbook...

[kamakshi]

it is wrap text FINAL
CONT
BUT THE COLUMN IS THE SAME WITH WRAP TEXT

[Siddharth Rout]

Can I see your workbook?

[kamakshi]

Koolsid
here it is wokrbook. thanks

[Siddharth Rout]

It is not "Final Cont" but "Final Contigency "

[kamakshi]

so i put using trim it is not working

[Siddharth Rout]

What is the exact code that you are using?

[kamakshi]

if cells(3,"c").text = trim(" Final contingency")

[Siddharth Rout]

Two things....

"Final Contigency " is different from " Final contingency"

1) spelling of Contigency and contingency is different
2) One starts with 'C' and the other starts with 'c'

[westconn1]

try
if trim(lcase(cells(3,"c").text)) = trim(lcase(" Final contingency") )

this will remove any space from either end of both and remove all case sensitivity

[kamakshi]

i tried the same way also it does nor work out, is that any thaing wrap text

[Siddharth Rout]

Can you upload your original workbook?