GCM Home | Your Posts | Rules | DONATE | Bookstore | Facebook | Twitter | FAQs


Author Topic: Help with Excel Spreadsheet?  (Read 1566 times)

0 Members and 1 Guest are viewing this topic.

Offline admin

  • Administrator
  • *****
  • Posts: 6957
  • Manna: 223
  • Gender: Male
  • Sheriff of these parts
    • View Profile
Help with Excel Spreadsheet?
« on: Sat Oct 11, 2008 - 16:02:25 »
If there's an excel aficionado who can help, I'd really appreciate it.

I've got about 4000 email addresses in a notepad document that are deliminted by a comma. I want to put them in an excel spreadsheet where there's one email address per row in column a

I don't know how. And I don't know the jargon used by those of you who use Excel a lot. So if you are kind enough to provide instructions, please explain it to me like I'm a fourth grade Democrat.

 ::crackup::

Christian Forums and Message Board

Help with Excel Spreadsheet?
« on: Sat Oct 11, 2008 - 16:02:25 »

Offline Nevertheless

  • Global Moderator
  • *****
  • Posts: 13259
  • Manna: 427
  • Gender: Female
  • Set a guard over my mouth, O Lord!
    • View Profile
Re: Help with Excel Spreadsheet?
« Reply #1 on: Sun Oct 12, 2008 - 16:37:29 »
Open Excel.

Click "File" then "Open"

Browse to the folder containing the file you want to open. Be sure to choose "text files" in the drop down menu next to "Files of type:" or the file you want won't show up in the list.

When you find the file and open it the Text Import Wizard will pop up. The box by "delimited" should be checked. Click "next".

The box by "Comma" should be checked. Click "next".

Follow instructions for step 3 (they are clear) then click "Finish".

That should do it.

Be sure to save the file as an Excel file so you don't have to do this again the next time!

Christian Forums and Message Board

Re: Help with Excel Spreadsheet?
« Reply #1 on: Sun Oct 12, 2008 - 16:37:29 »

Offline admin

  • Administrator
  • *****
  • Posts: 6957
  • Manna: 223
  • Gender: Male
  • Sheriff of these parts
    • View Profile
Re: Help with Excel Spreadsheet?
« Reply #2 on: Tue Oct 14, 2008 - 21:15:01 »
Great, thanks. It opened the Excel doc with one email address in each column. How do I now change it to where there's one email address per row?

HRoberson

  • Guest
Re: Help with Excel Spreadsheet?
« Reply #3 on: Tue Oct 14, 2008 - 23:46:31 »
Highlight the row(s) that contains the data.

On the Home tab, select "copy." Do NOT select "cut."

Select the paste area that you want to use - do not overlap any of the cells in the "copy" or "paste" areas. So, if you're data starts in cell A1, and the first open cell on the worksheet is A14, you will want to select A14 on the original worksheet, or change to another worksheet and select A1 on the new worksheet before pasting. 

On the Home tab, select the little arrow below "Paste."

Select "Transpose"

Your data should flow down from your selected input cell.



Christian Forums and Message Board

Re: Help with Excel Spreadsheet?
« Reply #3 on: Tue Oct 14, 2008 - 23:46:31 »

Offline admin

  • Administrator
  • *****
  • Posts: 6957
  • Manna: 223
  • Gender: Male
  • Sheriff of these parts
    • View Profile
Re: Help with Excel Spreadsheet?
« Reply #4 on: Wed Oct 15, 2008 - 01:07:56 »
Thanks HR! Thanks very much. Now I've learned that for some reason it didn't bring in all the email addresses. Maybe there were too many. I checked the help section and it suggested doing several smaller imports. Sheesh, that will take a while.

Thanks very much for your help!!

Christian Forums and Message Board

Re: Help with Excel Spreadsheet?
« Reply #4 on: Wed Oct 15, 2008 - 01:07:56 »