Combining cells with text

  • Thread starter Thread starter Nadine
  • Start date Start date
N

Nadine

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.
 
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.
 
Back
Top