White space

[anetal179]

Hi.

I have a problem. I have a formula: if [period]= '3' then ' 3' endif

When I export to excel the leading white space doesn't exist. How to solve this problem?

[MarqueeCrew]

Here's a wild guess. 

try:   "' 3"

 cheers,

 mark

[Qiu]

@anetal179 

It appears to me that your ' 3'  contains one space.

[pedrodrfaria]

Hi @anetal179 

Instead of a space, would a invisible character work?

Attached the workflow using it.

Pedro.

[grazitti_sapna]

Hi @anetal179,

Here is what I tried and it works for me.

I hope it Helps.

[anetal179]

I doesn't work. When I open the excel I see: 

[anetal179]

Thanks. But result is:

' 3

I need only white space and number (without ') 

[anetal179]

Thanks. I need oly one white space, because the rest of the data is in this format and I have to be consistent

[pedrodrfaria]

@anetal179 

I don't know if any of the replies were intended to me, but would the Invisible Character work for you in this case? Or do we NEED it to be a space character?

[anetal179]

@pedrodrfaria I need a space character.