Remove spare from MS Forms

Like (0) Share

Report

Posted on 27 May 2021 16:55:29 by Reimer

Hi Guys,

I am using a MS Forms to trigger a flow. In this Flow it needs to fill collumns within excel. But how do I remove blank space from an awnser giving in MS Forms?

Can anyone help?

All responses (1)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on 27 May 2021 at 19:15:31

Like (1)

Report

Re: Remove spare from MS Forms

Hi @Reimer

By blank space, do you mean spaces? " He llo "?

You can use the expression trim(' He llo '), returns 'He llo'. by removing leading and trailing whitespace.

If you want to remove all whitespace, use replace, replace(' h e l l o', ' ', '')

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉