In excel, I have values in Col H as follows
31 May 1996 (Orig – 31 /05/1996)
31 May 1995 (Orig – 31/05/1995)
31 May 1993 (Orig – 31/05/1993)
31 Mar 1997 (Orig – 31/03/1997)
and I want to format the cells to appear like this but in the same cell? Not in two separate Columns but in same cell
| 31 May 1996 | (31/05/1996 ) |
| 31 May 1995 | (31/05/1995 ) |
| 31 May 1993 | (31/05/1993 ) |
| 31 Mar 1997 | (31/03/1997 ) |
I want the stating values to be on left of the cell and the string within () to be right side of the cell. How to achieve it?
5