Thanks Tim. One more question for anyone else on this thread. The method you mentioned is great for a list, however, what I need to do is convert four line blocks of text into four columns.
In other words, I need to convert: Bananas No Doubt Columbia Records Sony Music Inc. Get Lucky Daft Punk Columbia Records Sony Music Inc. Heartbroken Meaghan Smith Capitol Records Warner Music/BMG to: Bananas No Doubt Columbia Sony Music INc. Get Lucky Daft Punk Columbia Sony Music Inc. Heartbroken Meaghan Smith Capitol Warner/BMG and so on. What I've done is pasted everything as a single column in my first worksheet which I've called Raw Input. In my second sheet, I've put a formula in to reference the Raw Input sheet and cell that I need. So, in the prior example, all song titles are listed like this: =Raw Input:Table 1:A1 =Raw Input:Table 1:A5 =Raw Input:Table 1:A9 In the next column, I've reiterated the process, however starting at A2 and going every 4 cells. I'm wondering if there's a formula to automate this process, like telling Numbers to fill down the column with every nth cell. If there's a way to do this, I'd save myself lots of time! Thanks, Kevin On 2013-04-20, at 4:29 PM, Tim Kilburn <kilbur...@gmail.com> wrote: > Hi, > > How about you try this in TextEdit: > > 1. Open the document. > 2. Make sure the document is in Plain Text from under the Format menu. > 3. Press cmd-f to bring up the Find dialog. > 4. In the Find field, press Option-return. That's pressing the return key > while the Option key is down. > 5. In the Replace field, press Option-tab. That's pressing the tab-key > while the Option key is down. > > What this does is look for return characters and replace them with tab > characters. Now when you import this into Numbers, it will place the items > horizontally instead of vertically. > > The issue that may arise though, is that if you use the Replace All > functionality, the entire document will go across the Spreadsheet in columns > which may not be your desired result. What I'd do to fix this, is search for > the key words like "Incorporated" in "Sony Music Incorporated" then replace > the tab in that case with a return. You may wish to search for the exact > phrase, not just "Incorporated" so that things like "Frustrated Incorporated" > or "Pop Music" do not confuse your replacing operation. Using this method, > it should be able to essentially, divide these into groups so that those four > items are placed in a row then the next song or item is placed within the > next row. You'll need to do this in the order I've mentioned here as the > tabs must be created first then the return dividers second. > > Hope this makes sense. > > Later... > > Tim Kilburn > Fort McMurray, AB Canada > > On 2013-04-20, at 1:17 PM, Kevin Shaw <tvsound...@gmail.com> wrote: > >> Hi, >> >> I'm wondering if anyone knows of a way to convert columnar text in a Pages >> or TexEdit document into a Numbers spreadsheet, however I need the lines of >> text to be converted into columns. >> >> For example: >> >> Bananas >> No Doubt >> Columbia >> Sony Music Inc. >> >> should be converted to: >> >> Bananas No Doubt Columbia Sony Music Inc. >> >> This way, each line maps to a column in Numbers. >> >> I'd hate to have to do this the long way. >> >> Thanks, >> Kevin >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com. >> To post to this group, send email to macvisionaries@googlegroups.com. >> Visit this group at http://groups.google.com/group/macvisionaries?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> > > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com. > To post to this group, send email to macvisionaries@googlegroups.com. > Visit this group at http://groups.google.com/group/macvisionaries?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
