Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining text from several cells into 1 cell | Excel Worksheet Functions | |||
Combining text cells. | Excel Discussion (Misc queries) | |||
Combining text from different Cells IF | Excel Discussion (Misc queries) | |||
combining text & number from different cells | Excel Discussion (Misc queries) | |||
combining text from 2 cells | Excel Discussion (Misc queries) |