Adding Numbers in the same Cell

  • I have a Column of cells that I get from another program. In the column some cells are blank, some cells have 1 number, and then some cells have several numbers separated by 3 spaces EX.(1 1 5 4). Is there a way that I can add these values together in one cell so in my example i would add them in to one cell valuing 11?

  • This will loop through Column A and place the sums in column B
    I believe it will only work for single digits

  • Hello,


    Your question reminds me of a trick designed by Bob Umlas ...:wink:


    Say your cell is A2 ... and it is holding : 1 1 5 4


    1. Create a name ( Ctrl F3 ) e.g. Trythis and in Refers To ... place this formula

    Code
    1. =EVALUATE(SUBSTITUTE(A2," ","+"))


    2. Then in whatever cell ... just type in

    Code
    1. =Trythis


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Carim,
    That great,
    Gave me the idea to replace the spaces with "+"

  • Hi,


    Glad this could help you out ...:wink:


    Evaluate can be a very handy function ...!!!

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)