Converting string of info in one cell into multiple

[Guest]

I have one cell containing a street, city, state and zip that I want
converted to 4 individual cells without manually entering each cell.

Thanks,
Becky

 

[JE McGimpsey]

Try Data/Text to Columns. Use "," as a delimiter, then a space character.

If you have states with two-word names spelled out, do a search and
replace first to replace them with one word names, then reverse it after
you do the Text to Columns.