SOLVED

RFID CSV file

%3CLINGO-SUB%20id%3D%22lingo-sub-2769607%22%20slang%3D%22en-US%22%3ERFID%20CSV%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769607%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20RFID%20scanner%20software%20is%20adding%20a%20space%20to%20the%20end%20of%20the%20number%20when%20it%20saves%20to%20CSV%20file.%3C%2FP%3E%3CP%3ESo%20my%20tag%20management%20software%20doesn't%20recognize%20the%20format.%3C%2FP%3E%3CP%3EI%20can%20open%20each%20cell%20and%20manually%20delete%20the%20space%20-%20bit%20of%20a%20pain.%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20bulk%20delete%20the%20extra%20space%3F%3C%2FP%3E%3CP%3ECopy%20%2C%20paste%20in%20different%20format%2C%20saving%20in%20different%20file%20type%2C%20clear%20format%20doesn't%20work.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2769607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2769632%22%20slang%3D%22en-US%22%3ERe%3A%20RFID%20CSV%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161813%22%20target%3D%22_blank%22%3E%40Binny%3C%2FA%3E%26nbsp%3BSuppose%20your%20numbers%20with%20the%20extra%20space%20are%20in%20column%20A%2C%20starting%20at%20A1%2C%20enter%20%3DTRIM(A1)%20in%20e.g.%20B1%20and%20copy%20it%20all%20the%20way%20down.%20Now%20copy%20column%20B%20and%20paste%20it%20%3CSTRONG%3Eas%20values%2C%3C%2FSTRONG%3E%20back%20into%20column%20A.%20Now%20you%20can%20delete%20column%20B.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

My RFID scanner software is adding a space to the end of the number when it saves to CSV file.

So my tag management software doesn't recognize the format.

I can open each cell and manually delete the space - bit of a pain.

Does anyone know how to bulk delete the extra space?

Copy , paste in different format, saving in different file type, clear format doesn't work.   

3 Replies
best response confirmed by Binny (New Contributor)
Solution

@Binny Suppose your numbers with the extra space are in column A, starting at A1, enter =TRIM(A1) in e.g. B1 and copy it all the way down. Now copy column B and paste it as values, back into column A. Now you can delete column B.

No that space is still there after I paste back.
Do I need to specify what to trim?
OK problem sorted I needed CLEAN
thanks for putting me on the right track