+ Reply to Thread
Results 1 to 4 of 4

Adding an element to all the formulas in the row

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Yerevan, Armenia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Adding an element to all the formulas in the row

    Hi,

    I have a row with various formulas and I want to add an element to all of them (I need all of the formulas to also add one additional element). How can a quickly do that for the whole row?

    Thank you,
    A_K

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Adding an element to all the formulas in the row

    Use 'find and replace'
    Find: this is a part of the original formula
    Replace: The part of the original formula & additional element
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    Yerevan, Armenia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Adding an element to all the formulas in the row

    Hi popipipo,

    Thank you for your response. My problem here is that my functions change across the row, i.e. there is not a common part of the formula in the different cells of the row that I can replace with the new one.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Adding an element to all the formulas in the row

    If there are no similarities between the formulas I fear that you have to do everything manually.
    Good luck

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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