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.
