If you have data imported from another source, sometimes the line breaks are also represented by character 13 instead of 10. To enter the numbers you need to use the numbers from the Num-lock part of the keyboard (with the numbers above the letters on your keyboard it doesn't work). On my computer in the box there is then a small dot blinking when the cursor is still in the entry box. To do this, press and hold the Alt key, and then enter the numbers 010 from the numeric part of the keyboard.
In the "Find what:" box you can enter the line-break code, which is character number 10. If you want to replace these line-breaks with for example a space, you can do this with Excel's find/replace command. In this case the author has used the shortcut Alt+Enter to put the last name on a new line.īut now we need it together on a single line, with a space between the first- and last name instead of a line break. If you give some details on your data and what you want the results to look like in Contacts (whether you want the addresses to be "Personal" or "Work" rather than "Other" etc., whether you have additional columns, etc) this can be customized without much trouble.There are few quick methods to remove the line breaks and carriage returns in cells.īy default you might not know an easy and quick way to do this but it is fairly simple, either with just Excel, or with the help of ASAP Utilities. (If "nothing happens" the first time make sure Script Editor.app is checked at System Preferences > Security & Privacy > Privacy > Accessibility).īest to test using a small table first to make sure it is doing what you want. Click the triangle "run" button in Script Editor.Click in Numbers table containing the addresses.Copy-paste script into Script Editor (in Applications > Utilities).The script below will import this into Contacts, preserving the line returns.
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)
