I was approached at work with a question about extracting a specific portion from a formula.
Here is the formula which was hard coded at least for the last two portions of the equation: =J7+11+3
Further example:
=J7+11+3
=J8+10+2
=J9+9+4
The user wanted to extract the last number so they could sum those values. In this example, 3, 2, and 4
The only method that came to mind was text-to-columns with a find and replace.
First I hightlighted the column and replaced the = with --
Copied that column to a new column and split text by the + using text-to-columns
Is there an easier method and/or, what if I just want to extract the +3, +2, +4, etc.,?
Bookmarks