You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I stop Numbers treating commas as tabs when I paste in text?

For years I have been able to use TextEdit to place column-separating tabs in text that I then want to paste into two or more columns in a Numbers file. Now, when I try to do that, Numbers makes up its own mind how many columns my text should be spread over - probably by reading commas as further tabs.

Please can some one tell me how I can stop it doing that?

iMac 27", macOS 10.12

Posted on Jan 26, 2020 2:14 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 26, 2020 7:42 AM

After you paste, a message appears above-right saying "Table data was imported" and you can click Adjust Settings. The various delimiters (separators) can be toggled on and off.

Similar questions

2 replies

How do I stop Numbers treating commas as tabs when I paste in text?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.