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.
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.