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!