Hey everyone,

So here's the problem. I have an Excell file with information about cliënts (Name, adress, etc) which I want to import into an Access database later. The point is that some data wasn't properly entered. The main problem I'm having is that some names are entered in caps, or not starting with a capital characters.

So now my question, is there a way to make a group of cells automatically start with a capital characters, and followed by standard characters. (For example, if the name spells "LONDON" I want it to automatically change into "London")

Thanks for your time
Greets,
Sebastian.