You'll know within a minute or so whether this solution will work for you).įor example if you have the following table in Numbers. (No scripting knowledge needed to use just copy-paste. An AppleScript can sometimes be very efficient in transferring data between apps on the Mac. I understand this only works via a CSV file format.ĬSV is not the only way. If things happen, you'll be able to get back to your original. You may have to proceed slowly, finding each return, and replacing only the ones that were originally in a cell.įortunately, using a text editor means you will be editing a copy of your data, not the original.
When you copy and paste the contents of a spreadsheet table into TextEdit (or any text editor) the result is a text document with tabs marking the columns and returns marking the lines, Find will not differentiate between these returns and those contained in a cell. Press command-F, click in the Find box, and press option-return to enter a return n the box.Ĭlick Find and Replace to open the Replace with box.Ĭlick in the box and type what you want to replace the returns with. Select the cells, copy, then paste into a new TextEdit document. Numbers 3 and Numbers 4 do not include this feature, so to replace returns in cells, you will need to use a text editor, such as TextEdit, included with your Mac's OS X software, and most easily accessed with a Spotlight search for 'text'. To enter one there, press command-F to open the Find dialogue, click in the box, and press option-return. Numbers '09 v2.3 accepts a paragraph break as a search character in Find. What version of Numbers are you using (Numbers menu > About Numbers)?
0 kommentar(er)
