I have a database file in MYOB in which the majority of information is in CAPS - ie. NAME AND ADDRESS are all caps!
Is there a way of importing into Excel or Access and removing caps and replacing with lower case.
Of course just to make it easy I also require first letter to be a Capital.
I have a sign making graphics program that can do it but can't get the data in there.