Forum Discussion
Solved
RFID CSV file
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 t...
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.
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.
OK problem sorted I needed CLEAN
thanks for putting me on the right track
thanks for putting me on the right track