Underscores

If you are looking for a formula field which would take the words

I want to have underscores between all my words

and have the formula calculate to be

I_want_to_have_underscores_between_all_ my_ words

the formula would be

List("_",

Part([my text input field],1," "),

Part([my text input field],2," "),

Part([my text input field],3," "),

Part([my text input field],4," "),

Part([my text input field],5," "),

Part([my text input field],6," "),

Part([my text input field],7," "),

Part([my text input field],8," "),

Part([my text input field],9," "))

The untested formula above should give you underscores betwene the first 10 words, so you will need to decide on how many words you need to handle.

Mark Shnier