Changing the ase of data in afield

[djclntn]

Pardon my title, I didn't quite know how to word my inquery. I've purchased & downloaded this Zip Code Database which has every Zip zcode in the U.S. which I use for different projects/reasons. The problem is, ALL of the data is upper case letters. I was wondering if in Access (or Excel) is there any way I could convert all of the letters (except the first letter) from upper case to lower case letters?



DELWARE to Delaware

[RuralGuy]

Look in Help for the StrConv Function.

[djclntn]

I was unable to find what I needed. Might you have some other suggestions?

[djclntn]

I wnt on Google & I think I've found what I needed. Thanks

[RuralGuy]

I was unable to find what I needed. Might you have some other suggestions?

Proper Case is what you were looking for.