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

    Feb 12, 2007
    Neander Valley, Germany; just outside Duesseldorf
    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


    May 16, 2008
    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