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?
Here's a wild guess.
try: "' 3"
cheers,
mark
It appears to me that your ' 3' contains one space.
Hi @anetal179
Instead of a space, would a invisible character work?
Attached the workflow using it.
Pedro.
I doesn't work. When I open the excel I see:
Thanks. But result is:
' 3
I need only white space and number (without ')
Thanks. I need oly one white space, because the rest of the data is in this format and I have to be consistent
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?
@pedrodrfaria I need a space character.