Question

I've looked through SpreadSheetPlugin. I want the reverse of PROPERSPACE - I want to convert a string of blank-separated words into a Wiki Word.

TRIM won't remove spaces between words TRANSLATE will replace the spaces with _ but doesn't seem to have an option to replace the with nothing LISTJOIN doesn't appear to recognize a null separator.

Is there something I haven't seen? Or is this a feature request for Spreadsheet plugin?

Environment

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

Hm, is this a subset of HowToDeleteCharactersFromAString?

-- FranzJosefSilli - 03 May 2007

Although tricky, it might be possible to do that with a number of CALC functions. Basically you need to capitalize characters after spaces, then remove the spaces.

A new $MAKEWIKIWORD() function could be added to the plugin.

-- PeterThoeny - 08 May 2007

I think a MAKEWIKIWORD function would be useful

-- VickiBrown - 21 May 2007

re: a number of CALC functions, I'm guessing this could be done by first using PROPER, then the magic Peter posted at Support.HowToDeleteCharactersFromAString

Of coourse, I also think a MAKEWIKIWORD funcction would be valuable.

-- VickiBrown - 19 Jul 2007