Sep 21 2021 12:12 AM
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.
Sep 21 2021 12:22 AM
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.
Sep 21 2021 12:41 AM
Sep 21 2021 01:49 AM
Sep 21 2021 12:22 AM
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.