Separation of fields into files

[junedream]

Hi

This is an easy one, but I'm newcomer to Excel and would appreciate some help. How do I separate an excel file into smaller files per column fields (i.e. zip codes, alphabetical names). I've checked the manuals and it may be TOO basic to mention. Thank you for your help.

 

[seenfresh]

Hi

This is an easy one, but I'm newcomer to Excel and would appreciate some help. How do I separate an excel file into smaller files per column fields (i.e. zip codes, alphabetical names). I've checked the manuals and it may be TOO basic to mention. Thank you for your help.

Welcome to the board!

Let's distinguish your question - "How do I separate an excel file into smaller files per column fields" -

An Excel file is an Excel Workbook ex.. "myexcelfile.xls" I believe what you meant to convey in your question is how to separate a "cells" value into two separate values to be placed in different columns?

See link below for a quick look at some basic Excel terminology, this will help you with future questions and answers.

http://www.create.cett.msstate.edu/create/howto/MS_Excel_Basic_Terms_06-04-02.pdf

Below link will help you understand an Excel feature "Text to Columns" this may be the easiest way for you to separate your data...

http://www.worldstart.com/tips/tips.php/1153