Scott, that's a neat idea with the autofilter, although I would need to
write a macro in order for that to happen automatically. (My file is
updated on an ongoing basis by several people, and I wouldn't want to
have to do that operation manually.)
Earl, I didn't even know about the LEN function until just now -- and
I think I was only vaguely aware of the ISTEXT function. In the end, I
did something very much along those lines: (=IF(B1<"", *my operation*,
""))
Thanks very much to both of you. :)
--
shellshock
------------------------------------------------------------------------
shellshock's Profile:
http://www.excelforum.com/member.php...o&userid=24935
View this thread:
http://www.excelforum.com/showthread...hreadid=385124