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
General Discussions
Switcher Hangout (Windows to Mac)
Numbers - split cells
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="MacInWin" data-source="post: 1665963"><p>If you've created a table in Word, it transports to Excel cell for cell. Text, whether from Word or a text file, still has to be delimited, but Excel can import files delimited with commas, tabs, semicolons, spaces or any other character you choose. What I've done that works reasonably well is to do a global find/replace to put in some really unusual character right after every ". " (That's a period followed by a space) and then use that as a delimiter. Now each sentence gets its own cell.</p></blockquote><p></p>
[QUOTE="MacInWin, post: 1665963"] If you've created a table in Word, it transports to Excel cell for cell. Text, whether from Word or a text file, still has to be delimited, but Excel can import files delimited with commas, tabs, semicolons, spaces or any other character you choose. What I've done that works reasonably well is to do a global find/replace to put in some really unusual character right after every ". " (That's a period followed by a space) and then use that as a delimiter. Now each sentence gets its own cell. [/QUOTE]
Verification
Name this item 🌈
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Numbers - split cells
Top
