How do I use Replace to change a symbol into a word and a space?

Knack Community
1

I’ve got a field that often contains text that starts with a plus sign like this: “+Some Stuff Here…” and I need to change all the ones like that to “Plus Some Stuff Here…”

In a Text Formula, I’ve tried:

replace({Memo},+,Plus )

which has a space after the word Plus in the replacement text (between Plus and the right parentheses), but so far I can only get it to change the text to: “PlusSome Stuff Here…” where the word Plus is jammed up against the remaining text.

How can I accomplish this?

FYI I need to do this because I’m exporting the data into CSV and of course, starting a field with + is causing the export to throw #NAME? into the exported field (it thinks it’s an Exel formula).

Thanks!