Remove spacing in text column

%3CLINGO-SUB%20id%3D%22lingo-sub-857699%22%20slang%3D%22en-US%22%3ERemove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857699%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20have%20a%20simple%20single%20line%20text%20column%20for%20email.%20The%20email%20address%20is%20essential%20for%20running%20a%20Power%20shell%20script%20so%20it's%20important%20is%20captured%20correctly.%20However%2C%20We've%20noticed%20some%20users%20entering%20spaces%20before%20and%20after%20the%20email%20address%20(most%20likely%20copying%20and%20pasting)%20which%20is%20causing%20issues%20with%20the%20script.%20How%20can%20I%20format%20the%20column%20to%20Trim%20the%20spacing%20before%20and%20after%20the%20text%20so%20that%20there%20is%20no%20spacing%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-857699%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857938%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857938%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409658%22%20target%3D%22_blank%22%3E%40SPFlowy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20add%20a%20calculated%20column%20to%20the%20list%20that%20uses%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ftrim-function-50b6f593-4801-4f06-81c5-3345e7f80ddd%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETRIM%20function.%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863503%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response%20however%20It%20does%20not%20seem%20to%20be%20working%20for%20me%20-%20the%20spaces%20still%20appear%20even%20after%20adding%20the%20TRIM%20function%20to%20the%20calculated%20value.%20How%20would%20Formula%20look%20on%20a%20single%20line%20of%20text%20column%3F%3C%2FP%3E%3CP%3EAppreciate%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863536%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20spacing%20in%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409658%22%20target%3D%22_blank%22%3E%40SPFlowy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132627i36F1FC32A12FB23B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20TRIM%20is%20not%20working%20I%20think%20there%20might%20hidden%20characters.%20View%20the%20email%20values%20in%20text%20editor%20that%20allows%20you%20to%20view%20hidden%20characters%20(i.e.%20NotePad%2B%2B).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

3 Replies
Highlighted

Hi @SPFlowy,

 

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

 

I hope this helps.

 

Norm

Highlighted

@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. 

Highlighted

@SPFlowy,

 

clipboard_image_0.png

 

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