Results 1 to 5 of 5

Adding multiple numbers within a single cell

Threaded View

  1. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Adding multiple numbers within a single cell

    You could also use a UDF...

    Add this to a new module in your workbook:
    Function Add(Rng As Range) As Variant
        Add = Evaluate(Application.Substitute(Rng, "/", "+"))
    End Function
    Then, in cell C69 type: =ADD(C68)

    - Moo
    Last edited by Moo the Dog; 01-29-2013 at 01:41 PM. Reason: h/t to Andrew Poulsom

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