Remove if there is a space in the start of the cell


in Column A, some cells contain an extra space in the start of the cell and some don’t.
“ab” starts with a space and “f” does not.

What I need is an if statement to remove the extra space at the start if there is one. otherwise just keep the value in the cell.

Can someone recommend me a node and a way to do it.

Thanks in advance
Book2.xlsx (8.6 KB)

Hello @kanishka271,

you don’t need if function for this. Simply use strip() function from String Manipulation node. It removes whitespaces from start and beginning of a string. You also have stripStart() and stripEnd() at your disposal in case you are removing whitespace only from start or only from beginning of a string.



This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.