Thread: Text-to-columns
View Single Post
  #1  
Old May 17th, 2010, 02:59 PM posted to microsoft.public.office.misc
yuppicide
external usenet poster
  
Posts: 11
Default Text-to-columns
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.