Converting string of info in one cell into multiple
 

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

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.



In article ,
bbrowning711 wrote:

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