Remove spacing in text column

[SPFlowy]

Hi,

We have a simple single line text column for email. The email address is essential for running a Power shell script so it's important is captured correctly. However, We've noticed some users entering spaces before and after the email address (most likely copying and pasting) which is causing issues with the script. How can I format the column to Trim the spacing before and after the text so that there is no spacing?

Many thanks

[#2]

Hi @SPFlowy,

You could add a calculated column to the list that uses the TRIM function.

I hope this helps.

Norm

[#3]

@Norman Young 

Thanks for your response however It does not seem to be working for me - the spaces still appear even after adding the TRIM function to the calculated value. How would Formula look on a single line of text column?

Appreciate your help. 

[#4]

@SPFlowy,

If TRIM is not working I think there might hidden characters. View the email values in text editor that allows you to view hidden characters (i.e. NotePad++).

Norm