Text-to-columns

Y

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.
 
Y

yuppicide

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to center adjust text above and image in a two column document. 1
Two columns : Continuous two columns vs Parallel two Column 1
right, mid, left functions?? 4
Rows to columns with multiple sets 1
Mailing address block: sorting 1 row to columns 1
Text to column using multiple spaces?? CITY STATE ZIP 2
Excel spreadsheet - one column into two columns 2
Move rows into columns 3

Top