+ Reply to Thread
Results 1 to 8 of 8

Inserting same values to end of preexisting cell values

  1. #1
    Registered User
    Join Date
    08-21-2017
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    4

    Inserting same values to end of preexisting cell values

    Hi, I was wondering whether there is a quick way to insert the exact same value to the end of a cell with preexisting values without altering the preexisting values?

    For example, the preexisting formulas are as below:
    =1+2
    =1+3
    =1+4

    Say I wish to add "-1" to end of each cell so that the new formulas are as below:
    =1+2-1
    =1+3-1
    =1+4-1

    I've been manually copying and pasting the equivalent of "-1" into my preexisting array of cells - is there a faster way to do this? Thanks all.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,861

    Re: Inserting same values to end of preexisting cell values

    Do you need a formula in the cell or will it suffice to just change the value by -1?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-21-2017
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    4

    Re: Inserting same values to end of preexisting cell values

    Ideally I'd have the full formula. The reason is because I'm in a transaction process at the moment that sees the model being regularly updated, and with line items often being shifted. For purposes of efficiency, I'd ideally be able to link all the cells I need to change to one flex cell containing the relevant delta without having to insert additional lines.

  4. #4
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    484

    Re: Inserting same values to end of preexisting cell values

    Maybe, update your formulas to:

    =1+2+A1
    =1+3+A1
    =1+4+A1

    and then place the desired value in cell A1 (e.g., 0 or -1)

  5. #5
    Registered User
    Join Date
    08-21-2017
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    4

    Re: Inserting same values to end of preexisting cell values

    @Root_, yup that's what I've been doing at the moment. The issue is that given the formulas are inconsistent I'm not able to drag, and have to manually insert the "+A1" reference. Unfortunately there's a large number of lines that require this adjustment.

    For a bit more context, I'm in the middle of project finance bid process where the financial model gets updated frequently, and sensitivity analysis has to be performed on it in relatively short turnaround times. The build of the model means that both the manual insertions method and inserting additional reference row methods are very time consuming. I was just wanting to see whether there was an easier option out there for when the next update of the model comes around.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Inserting same values to end of preexisting cell values

    Hi riding fish (how do your peddle? )

    I think you are looking for one of the "Paste Special" features. You copy into the keyboard buffer a number and then select where you want to add that value and Paste Special.

    Is this what you want?

    http://www.techrepublic.com/blog/mic...ting-in-excel/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  7. #7
    Registered User
    Join Date
    08-21-2017
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    4

    Re: Inserting same values to end of preexisting cell values

    It's more of a gliding action.

    Thanks, however my understanding of the paste special function is that it hard-codes the results. For audit purposes, I need the full calculation to be traceable.

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Inserting same values to end of preexisting cell values

    Could you use a helper column such that the preexisting calculation is done in one column and the delta is added in the other?
    In the attached file the delta (-1) is in cell A1, the preexisting calculations (=1+2...) are in A2 and down.
    Starting with B2 the delta is added to the value of the preexisting calculation, i.e. =A2+A$1, which may be dragged down the column.
    If this doesn't work for your situation, and seeing that there have been no other proposed solutions in the past 24 hrs, I would suggest uploading a sample worksheet that shows a bit of the process you are attempting.
    To upload a sample worksheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Inserting a group of text at the beginning of every cell with values in them
    By Bailey_Thomas in forum Excel General
    Replies: 5
    Last Post: 12-31-2014, 06:44 PM
  2. Replies: 8
    Last Post: 11-29-2014, 05:07 PM
  3. Replies: 11
    Last Post: 07-26-2008, 05:18 AM
  4. Inserting values into a cell without removing the old value
    By Aqua in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2008, 09:30 AM
  5. Inserting multiple values within a single cell.
    By maacmaac in forum Excel General
    Replies: 1
    Last Post: 09-25-2007, 05:41 PM
  6. Inserting a cell changes my formula values
    By shallina in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2006, 12:42 PM
  7. VBA- inserting multiple cell values into single textbox
    By VBA_MAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2006, 09:45 AM

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