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.

=proper(A1)
Copy down and then convert the formulas to values (Copy, Paste special, Paste Values)

Thank you you're a life saver.

[solved]