Find and Move Specific Text To Another Column - First Post

[Exsupero]

Hi to all,
I have a spreadsheet with several hundred addresses each written in a single cell in the format "street address, city, state, zip code" (see column A in attachment). My objective is to have each portion of the address instead appearing in individual columns (see olumns B, C, D, and E in attachment).

Thanks very much for everyone's help

[Logit]

.
Look at TEXT TO COLUMNS, located in the DATA TAB.

Plenty of examples on the internet.

[Exsupero]

Thanks for your feedback - extremely helpful.

[Logit]

.
You are welcome.