Excel formula question

I put together spreadsheets with cable ID information for uploading
into our database. The cables are broken down into individual columns
for Bldg TR, Room#, Seq.#, D or V. From these columns I want to
create a column that indicates the cableID as it might appear on a
label. For example MOFFIT-312-321-005-D
To get this I use the Concatenate command:
=CONCATENATE(S3,"-",T3,"-",U3,"-",V3,"-",W3)
This takes the value in each column and inserts a dash between them.

My problem is that not all cable ID's (older one) have all columns.
For example MOFFIT-201-1
In this case I end up getting double dashes or a dash at the end so
it ends up looking like this: MOFFIT--201-1-

Does anyone know what else I can add to the formula so it doesn't
double up the dashes or add to the end?

Thanks in advance for assistance.

Monica

------------------------------------------------------------------------
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/>.
Received on Tue Nov 21 2006 - 11:45:29 PST