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)

@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