If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining cells with text
I have two cells that both have text in them. Cell A2 contains the old
status. Cell B2 contains the new status. I'd like to keep the history of the old status and update it with the new status on top. So cell A2 will now look like: 5/6 New Status 4/20 Old Status Can this be done? I'm using Excel 2003. I'm guessing it will be VBA code but don't know what it will say. Thanks. |
#2
|
|||
|
|||
Combining cells with text
=A1 & " Old status" and copy paste special - values to keep the value
static. -- Regards Dave Hawley www.ozgrid.com "Nadine" wrote in message ... I have two cells that both have text in them. Cell A2 contains the old status. Cell B2 contains the new status. I'd like to keep the history of the old status and update it with the new status on top. So cell A2 will now look like: 5/6 New Status 4/20 Old Status Can this be done? I'm using Excel 2003. I'm guessing it will be VBA code but don't know what it will say. Thanks. |
#3
|
|||
|
|||
Combining cells with text
I'm looking for something that can be done more automatically. I can easily
do this as a more manual step but I'm looking for something that will do it for all the 1000+ rows I have. Any ideas? Thanks so much for responding. "ozgrid.com" wrote: =A1 & " Old status" and copy paste special - values to keep the value static. -- Regards Dave Hawley www.ozgrid.com "Nadine" wrote in message ... I have two cells that both have text in them. Cell A2 contains the old status. Cell B2 contains the new status. I'd like to keep the history of the old status and update it with the new status on top. So cell A2 will now look like: 5/6 New Status 4/20 Old Status Can this be done? I'm using Excel 2003. I'm guessing it will be VBA code but don't know what it will say. Thanks. |
Thread Tools | |
Display Modes | |
|
|