Prev: Making a template in Word?
Next: Product key is correct...it tells me it is not!
From: yuppicide on 17 May 2010 09:59
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.


From: yuppicide on 17 May 2010 16:32
Oops.. meant to post this in Excel, oh well. No clue what I did, but I got
it to work eventually.

"yuppicide" <yuppicide138(a)optonline.net> wrote in message
news:OQIrvkc9KHA.4308(a)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.
>


 | 
Pages: 1
Prev: Making a template in Word?
Next: Product key is correct...it tells me it is not!