View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default 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.