Hmmm. Never used TRIM before, so it's nice to know about it, but I couldn't
make it work either. I should have mentioned, I am using SEARCH because C7
contains text and a date (and is based on a VLOOKUP) - so it's not just
straight text.

Many thanks for your suggestions.

"Max" wrote:

Maybe you need TRIM ..
Try: =IF(TRIM(C7)="","", ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Vibeke" wrote:
Hi Max,
Thanks, I tried that but for some reason it returns #VALUE! I am not sure
why. Any ideas?
I guess I could insert another coloumn and then use ISERROR, but it seems
clunky.
Thanks
Vibeke