A user form for data entry would allow you to control (future) data entry but that doesn't help much with what you've already got.
Have a look at this, I've assumed the first thing on each line will be the userid and it will always be 3 characters long then next will be the entered date, but if the date is first there will be no userid.
Let me know if this will be of use.
Good luck.
|