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?

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

this will replace all spaces with a dash.

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, 200817 yr by Guest
Added update and fixed typo

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

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