1 / 5

Importing Data to Excel

Importing Data to Excel. Suppose you have a delimited* text file and you need to bring it into Excel. Follow these steps…. Go to the data tab and click on “from text”. *Delimited means text separated into fields by a character such as a tab or a comma. Choose delimited and then click next.

redell
Download Presentation

Importing Data to Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Importing Data to Excel

  2. Suppose you have a delimited* text file and you need to bring it into Excel. Follow these steps… Go to the data tab and click on “from text” *Delimited means text separated into fields by a character such as a tab or a comma.

  3. Choose delimited and then click next. Choose the type of character that is delimiting the fields. You will see the sample data below change when you pick the right one.

  4. If you have a zip code field, be sure to switch the type of data to text, so you do not lose leading zeros. Then click finish and look at your data carefully to make sure everything went ok.

  5. Save the file as an Excel workbook. You are now ready to use your address list in a mail merge.

More Related