Automatic blank space deletion problem (QR Code, Google Sheets, Add an Entry, Blank Spaces)

I want to store exactly the same data as the QR code contains. But when I add an entry through scanning the QR code, blank spaces will be all deleted when it is stored to the Google Sheets.

Before saving the entry the data will be like this.

[)> 06 P7183885530 10SB3 Z;45P 2P Z;17Q0001000 30T210721 2C Z;D Z;46P 1W 22VF11 Z;26P Z;23V895 16D Z;6V 31T 1C1T-0FJ2OA

After saving the entry, the data will be like this.

[)>06P718388553010SB3Z;45P2PZ;17Q000100030T2107212CZ;DZ;46P1W22VF11Z;26PZ;23V89516DZ;6V31T1C1T-0FJ2OA

If I copy and paste the data, it goes like this:

[)>06P718388553010SB3Z;45P2PZ;17Q000100030T2107212CZ;DZ;46P1W22VF11Z;26PZ;23V89516DZ;6V31T1C1T-0FJ2OA

Is there any way to avoid this problem??

Thank you.

Solved Solved
0 7 1,291
1 ACCEPTED SOLUTION

Yeah, sounds like a good idea to me.

View solution in original post

7 REPLIES 7