Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...

The Text Join function combines text from multiple cells or ranges. The Filter function extracts data that meets specific criteria. The Vstack function vertically stacks arrays or ranges of data.