Hi
I have 2 or more rfid readers which using HID enter data into focused calc spreadsheet, the tag data is entered into focused column. Work great. But all readers show their tag reading in the same column.
In adjacent column I would like to auto enter the USB port number of device which read the tag data. eg:
| col B | Com C |
|---|---|
| (TAG#) | (USB id) |
| 123232 | 2 |
| 876234 | 4 |
| 98234 | 1 |
| etc | etc |
How do I achieve this
Thanks
Charles Harris
[LeroyG added format to the table]
Result similar to putting a date or time in the adjacent column, when entry made.
Charles
So you wish to have 123232 in the first column and 2 in the second.
.
Best way would be if your reader can use a tab-char instead of space. Check documentation for this (Wich reader do you use?)
.
Otherwise you may mark the inserted data and use text-in-columns from menu Data to split the fields at space as separator.
.
If you fill a prepared sheet, it would also be possible to extract the values by formula, if necessary.