Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Parse Before Line Break
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Rick Rothstein, post: 3801435"] If the text in A1 (or another cell if this formula is copied down) does not have a Line Feed, your formula will error out. This is probably the simplest fix to your formula for that possibility... =LEFT(A1,FIND(CHAR(10),A1&CHAR(10))-1) -- Rick (MVP - Excel) [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Parse Before Line Break
Top
