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 Misc
How to replace a constant from a cell containing date and time
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Claus Busch, post: 7409489"] Hi, Am Wed, 3 Oct 2012 10:28:53 +0000 schrieb BACITH: select your column => Data => Text to Columns => Fixed Width => Next => put 1 delimiter behind the opening bracket and one in front of the closing bracket => Next => first and third column = Do not import the column => Finish Or do it with formula: =--TRIM(SUBSTITUTE(MID(A1,FIND("(",A1)+1,99),")",)) Regards Claus Busch [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How to replace a constant from a cell containing date and time
Top
