I have this sample data in Excel and would like to know if it could be edited to proper case with conditions. The part numbers need to remain upper case but the words should be proper case. The first column is before and the second is the result I would like. I have about 20K records so it would be nice to automate the process.

Does anyone know of a way to accomplish this? Thank you

[Code]
99999 TRUNNION ASSEMBLY 99999 Trunnion Assembly
99999 SENDING UNIT 99999 Sending Unit
CE2150H13YY25 CE2150H13YY25
CE2151H15YY15 CE2151H15YY15

[Code]

I tried to paste the table but the data shifted sorry.