+ Reply to Thread
Results 1 to 6 of 6

Extract numbers from a sum formula inside a cell

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Bucharest, Romania
    MS-Off Ver
    2007
    Posts
    2

    Extract numbers from a sum formula inside a cell

    Hello all,

    after searching for a solution all over the internet, without success, I've decided to ask the masters of vba excel present on this forum

    I need to extract the numbers from a sum inside a cell.

    Ex: in cell A1 I have the formula "=150+50+100"
    I need to extract the separate numbers from that formula to different cells
    The result I need is: A2 = 150, A3 = 50, A4 = 100

    Can anyone help me? Thanks in advance.

    Cycloneclau

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,851

    Re: Extract numbers from a sum formula inside a cell

    How is this to be done?

    As a formula?

    As A macro?

    Is the data always in that format or do we need to consider other operators, ie -, /, *,^.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,746

    Re: Extract numbers from a sum formula inside a cell

    Use the text to columns Icon on the Ribbon and set the separator as "+"

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,851

    Re: Extract numbers from a sum formula inside a cell

    How is this to be done?

    As a formula?

    As A macro?

    Is the data always in that format or do we need to consider other operators, ie -, /, *,^.

    This is a formula based approach.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-16-2014
    Location
    Bucharest, Romania
    MS-Off Ver
    2007
    Posts
    2

    Re: Extract numbers from a sum formula inside a cell

    Thanks for your help. I think that the tect to column approach will fit into my macro.
    When I have some time I will try the formula sent by you too, checking which is faster.

    Thanks
    Cycloneclau

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Extract numbers from a sum formula inside a cell

    Deleted post. The very similar answer was already provided by alansidman
    Last edited by AlKey; 07-17-2014 at 01:58 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract the first characters inside a cell up to a delimiter
    By pickslides in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2014, 08:50 PM
  2. [SOLVED] Formula to Extract Numbers from Text Cell
    By MHamid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2012, 04:08 PM
  3. Can I extract certain words from inside a cell?
    By kufta4 in forum Excel General
    Replies: 4
    Last Post: 03-30-2011, 11:01 AM
  4. [SOLVED] extract number and use in formula from text & numbers in cell
    By ivory_kitten in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-14-2006, 12:45 AM
  5. Replies: 2
    Last Post: 01-20-2006, 01:45 PM

Tags for this Thread

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