Results 1 to 3 of 3

Thread: Perform basic operations basen on a cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Administrator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,302
    Location
    You can try the below:

    In the ribbon go to: Formulas / Name Manager
    Click 'New'
    Put: EVAL in the 'Name' box
    In the 'Refers to' box put: =LAMBDA(x, EVALUATE(x))

    Then in your spreadsheet you can use the EVAL function you created as below:
    =EVAL(A1&B1&C1)
    EDIT: Forgot to mention, this may only work on Excel 365
    Last edited by georgiboy; 10-06-2023 at 02:43 AM.
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2408, Build 17928.20080

Posting Permissions

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