Question about Computers & Internet
Assuming 1) you're using Excel and 2) the addresses are written:
1234 Main St., Anytown, CA 90210
You can use "Text to Columns" feature (selected "Delimited" and check the box next to "comma"). This will split the data into 3 columns (address | city | state and zip). Then run the "Text to Columns" again on the "state and zip" column and use "Fixed width" to separate the state from the zip.
If the assumptions I used are incorrect, clarify and we'll try again.
Posted on Jan 06, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 17, 2014 | Microsoft Excel for PC
Oct 08, 2013 | Microsoft Office 2003 Basic Edition...
Sep 06, 2009 | Microsoft Office Professional 2007 Full...
Sep 05, 2009 | Corel WordPerfect Office X4 Home & Student...
Feb 17, 2009 | Microsoft Excel for PC
Dec 27, 2008 | Microsoft Office Standard for PC
Sep 29, 2008 | Microsoft Computers & Internet
Nov 22, 2007 | Microsoft Excel for PC
Sep 24, 2007 | Microsoft Office Standard for PC
Aug 20, 2007 | Microsoft Office Standard for PC
67 people viewed this question
Usually answered in minutes!