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.
Bookmarks