Formula

Question

Can someone help me with writing a formula.

My dynamic input has an output record that comes with one space in between the two words and instead I'm looking to be able to add another space using a formula. In other words, instead of having one space I need to have two spaces.

Any ideas on how to write this formula?

Emmanuel_G · Answer

@azakharyan ,

Two ways to achieve that :

Duplicate space.yxmd

flying008 · Answer

嗨，@azakharyan

Maybe you want the formula below:

替换（[输出] ，'' ， '' ）

Christine_Assaad · Answer

Hi @azakharyan

I used a simple Replace function as below. As you can see from the Space Count formula below, it now sees 2 white space.

You can also use Regex but I believe this is simpler. Cheers!