One possible method to extract the section of a cell in Excel that is not formatted with strikethrough is:
Note that this method works only if the strikethrough formatting is applied to the entire text in the cell, and not just to some parts of it. If the strikethrough formatting is applied to some parts of the text, a more complex method involving formulas or VBA code may be required to extract the non-strikethrough text.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2021-09-25 11:00:00 +0000
Seen: 10 times
Last updated: Sep 03 '21
How can a printable form be structured to meet the accessibility requirements of Section 508?
Why does the app shut down when switching to the Google Maps section in a Flutter application?
How can I make the html anchor link jump further?
What is the process of creating global parameters in OpenAPI?
How can numbered sections be applied to only a specific portion of the Asciidoc document?
What are the steps to log in to Github Enterprise within Visual Studio 2022?
How can form posts be managed in Umbraco11?
How to add Maven dependencies to IntelliJ IDEA?
How can I make a record that has a confidential section?
Can you assist me in decreasing the range of an Excel Timeline?