Hello everybody, I searched the forums and Google to no avail and am in need of serious help. I m by no means an Excel master.

I have a spreadsheet with over 7,000 records. I need the data in certain columns to be in Proper case, except if the "word" contains any numerals.

There are too many different exceptions (part numbers beginning with and containing both numerals and letters) to exclude them one by one.

Is there any way to return the column data as proper case and ignore any words that contain any numbers entirely?

Thank you in advance for any help / direction with this matter