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 Programming
Parsing a cell's value
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Rick Rothstein, post: 6397142"] Assuming the revision level always starts with "Rev:" (in that letter casing), you could do this... =TRIM(LEFT(A1,FIND("Rev:",A1&"Rev:")-1)) If the "Rev" is not always in that letter casing (that is, maybe sometimes it is "rev"), the replace FIND with SEARCH. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Parsing a cell's value
Top
