Results 1 to 9 of 9

Extract right portion of a formula

Threaded View

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Extract right portion of a formula

    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.,?
    Last edited by jeffreybrown; 12-23-2011 at 07:48 PM.
    HTH
    Regards, Jeff

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1