Results 1 to 3 of 3

Thread: getting rid of a part of formula using macro

  1. #1

    getting rid of a part of formula using macro



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi guys, one cell has this\formula =sum(x1,x2,x3)+x4+x5

    is there any way to make a macro get rid of anything AFTER the sum...ie x4 and x5?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Crossposted:

    Please Read: http://www.excelguru.ca/content.php?184


  3. #3
    apologies

Posting Permissions

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