Re: Excel formula question

It will be a long formula, but you could insert an IF() to test for a
non-empty field, and only insert the dash for non-empty, and an empty
string ("") where it is not needed.

...,IF(ISEMPTY(cellref), "", "-"),... (very roughly from memory).

Graham

--
Graham Patterson, System Administration
Dept. of Economics, UC Berkeley (510)643-5397
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.