Need to merge data into spreadsheet

Discussion in 'Mac Apps and Mac App Store' started by Cave Man, Mar 26, 2011.

  1. Cave Man macrumors 604

    Cave Man

    #1
    I have an unusual problem. I have spreadsheet (I have both Numbers and Excel) that I need to add a column of data to from another text file. This spreadsheet and text file contain 18,237 entries. The spreadsheet has columns A-F occupied with data for all 18,237 entries. What I want is to import the other file's 18,237 into column G of the spreadsheet. The file is currently saved as a text file and each entry begins with a '>' symbol. What's the easiest way to merge these?
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    If I understand your question correctly, you should be able to open the text file, Command-A to select all, Command-C to copy. Then go to G1 of the spreadsheet and Command-V to paste. If the ">" at the beginning of each line is a problem, you can find and replace that with nothing (to get rid of it), or replace it, adding a single quote in front, to make Excel treat it as text. Do that in the text file before you copy and paste to the spreadsheet. Let me know if I didn't understand the scenario. Screen shots might help to visualize.
     

Share This Page