Converting string of info in one cell into multiple

B

bbrowning711

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
 
J

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