How to capitalize everything before a certain character?

[Burrgogi]

In column A, I have some text:
Hello good day.mp3
Hello good day.flac
etc.

I'd like to capitalize everything before the period. I don't need the file extension capitalized.

I have a feeling that I need to combine the PROPER function with the FIND function but I'm struggling to find the right formula. I'm lost.

 

[Burrgogi]

Peter_SSs, that worked. I appreciate the help!

 

[Rick Rothstein]

Peter_SSs, that worked. I appreciate the help!

I am still wondering what the "rule" that I asked you about in Message #18 is. On the second "rule" question I asked, I was thinking about names like DreamWorks, SportsZone, CompuServe, etc.

 

[Peter_SSs]

Peter_SSs, that worked. I appreciate the help!

Good to hear. You're welcome.