Forum Discussion
Remove spacing in text column
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 ent...
Hi SPFlowy,
You could add a calculated column to the list that uses the TRIM function.
I hope this helps.
Norm
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.
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