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.

pasting text into numbers with commas to separate data no longer working

I have been pasting lists of vocab into numbers with one word followed by a comma then another word. Until recently pasting into numbers would automatically paste each word into a separate column. Now it pastes word 1, word 2 into a single cell.


What could I have done to disable this feature? It makes it very cumbersome now to create vocab lists.

Posted on Feb 1, 2020 9:27 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 1, 2020 3:39 PM

After you paste, a message appears above-right saying "Table data was imported" — beside it, click Adjust Settings. You can toggle the various delimiters e.g. commas on and off.

2 replies

pasting text into numbers with commas to separate data no longer working

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