Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

Q. I read your August 2022 JofA article about changing the case of text in Excel to upper, lower, and proper, but some of my data comes in sentence form. Is there any way to convert those text strings ...

Starting with the text in A1, I can change the text in excel , place your cursor in a blank cell, A2, and press Shift+F3, evoking this screen: Under Select a function , look for the command you want: ...