Text-to-columns

[yuppicide]

I have a column in Excel 2007 as such

Virginia Beach, VA 23464
Glen Allen, VA 23059
etc etc

How can I convert that into three columns? The text-to-columns button is
greyed out.

Want City, State, and Zip in their own separate columns.

 

[yuppicide]

Oops.. meant to post this in Excel, oh well. No clue what I did, but I got
it to work eventually.

"yuppicide" <yuppicide138@optonline.net> wrote in message
newsQIrvkc9KHA.4308@TK2MSFTNGP04.phx.gbl...
>I have a column in Excel 2007 as such
>
> Virginia Beach, VA 23464
> Glen Allen, VA 23059
> etc etc
>
> How can I convert that into three columns? The text-to-columns button is
> greyed out.
>
> Want City, State, and Zip in their own separate columns.
>