Christian Forums and Message Board

Specifics and Interests => Computer Assistance => Topic started by: admin on Sat Oct 11, 2008 - 16:02:25

Title: Help with Excel Spreadsheet?
Post by: admin 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::
Title: Re: Help with Excel Spreadsheet?
Post by: Nevertheless 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!
Title: Re: Help with Excel Spreadsheet?
Post by: admin 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?
Title: Re: Help with Excel Spreadsheet?
Post by: HRoberson 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.


Title: Re: Help with Excel Spreadsheet?
Post by: admin 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!!