Thank you all for your suggestions.

SauveC--

I did try your suggestion combined with Julie's. It worked perfectly for
the first cell. When I tried to drag the fromula down the rest of the
worksheet, however, I get a "#VALUE" error. Now what? :)