Inset "dashes" between words

[selfstorage]

I have a list of all the cities in the usa. I need to be able to replace he space between the words with a dash "-". Sometimes the city is 1,2 or 3 words. Can anyone help?

[Ocean West]

You could use substitute(CityList ; " " ; "-" )

this will replace all spaces with a dash.

[LaRetta]

But what if the city is two words? Are you saying your list looks like:

San Francisco, Detroit, New Mexico, Los Angeles, Denver

... and you want it to look like:

San Francisco - Detroit - New Mexico - Los Angeles - Denver ?

Please clarify a bit for us.

UPDATE: Why don't you split them into a table with records now while you have the chance, since that's how they should be anyway?

Edited April 6, 2008 by Guest
Added update and fixed typo

[selfstorage]

that did the trick........thanks so very much.

[selfstorage]

The above solutions was what I needed. Thanks for the help! I really appreciated it