Sample Header Ad - 728x90

How to import text to columns and import numbers to text in macOS Numbers?

0 votes
1 answer
2315 views
Windows Excel allows me to paste a body of text and in the bottom right corner of the pasted content, a menu prompt will pop up that can initiate the "Text Import Wizard" to import delimited text into columns (text separated by commas or spaces, for example). In Numbers, such an option doesn't exist that I know of. Second, how can I import text (including numbers) as text? With windows I can do both of these functions with the Text Import Wizard and with Numbers I can't do either. The only solution I've found to the first problem is to download a custom workflow that I found in this Apple Community thread: https://discussions.apple.com/thread/8293955 And a less elegant solution is also discussed here but it's much more clunky: https://apple.stackexchange.com/questions/111512/how-can-i-do-text-to-columns-in-numbers?rq=1 Regardless, I still haven't found a way to import numbers as text.
Asked by John Doe (1 rep)
Oct 15, 2020, 02:53 AM
Last activity: Jul 22, 2025, 08:06 PM