Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Desktop Hardware
iWork Numbers - using a semicolon (;) to format rows and columns
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mrplow" data-source="post: 1550419" data-attributes="member: 38928"><p>Unfortunately Numbers doesn't see semicolons as a valid column separator. But it does like tabs, so the best method is to replace all the semicolons in your file with tab characters. </p><p></p><p>Here's how:</p><p></p><p>Open the text file on TextEdit</p><p></p><p>Go to <strong>Edit</strong> - <strong>Find</strong> - <strong>Find & Replace</strong></p><p></p><p>Enter a <strong>;</strong> in the first field and a tab in the second field (to 'type' a tab hold option and hit tab. You'll see the cursor move a tab space)</p><p>Now hit <strong>All</strong> and then <strong>Done</strong>. This will replace all semicolons with tab characters.</p><p></p><p>Now go to <strong>Format</strong> - <strong>Make plain text</strong></p><p></p><p>Now save the file and open in Numbers</p></blockquote><p></p>
[QUOTE="mrplow, post: 1550419, member: 38928"] Unfortunately Numbers doesn't see semicolons as a valid column separator. But it does like tabs, so the best method is to replace all the semicolons in your file with tab characters. Here's how: Open the text file on TextEdit Go to [B]Edit[/B] - [B]Find[/B] - [B]Find & Replace[/B] Enter a [B];[/B] in the first field and a tab in the second field (to 'type' a tab hold option and hit tab. You'll see the cursor move a tab space) Now hit [B]All[/B] and then [B]Done[/B]. This will replace all semicolons with tab characters. Now go to [B]Format[/B] - [B]Make plain text[/B] Now save the file and open in Numbers [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Desktop Hardware
iWork Numbers - using a semicolon (;) to format rows and columns
Top