ParseCellData\Copy

G

gh

I have an Excel 97 speadsheet that has the city, state and zip code in
column A(Houston, TX 77095). Some of the zip codes have the zip + 4 code
as well. I need to copy the city to column B, state to column c and zip
code to column d. Is there a macro that can do this?

TIA
 
D

Damon Longworth

Try highlighting the column and using Text to Columns under the Data menu.
Use a delimiter and try a space.



--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
 

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

Need VLOOKUP to Work Two Ways 0
FormattingLost 2
Rows to Columns - Diff Size Rows of Data 4
vLookUp return several columns? 5
Spliting rather mixed up address 7
Help: Find Matching Cells, If - Then Move Cell With Self 2
How do I setup a cascading combo boxes? 9
Extracting Data out of a string 9

Top