I am using an input box to enter a vehicle registration. how can i format it so that it always the same regardles of how it was typed in
for instance ABCD 123 is typed in by one person but another may type it in as ABCD123.
It needs to populate a cell in the main sheet in the format of 4 space 3 (as in british number plates) so it can verify the vehicle against another spreadsheet.
also needs to always be in capital letters
I'm guessing left$ or right$ would do this but have never used this funtion and my last few hours atempting to has failed
there are over 140 vehicles in the data base so data validation is to long
also due to a tied in yard managment screen its not possible to enter the vehicles in both formats