I would like a formula if possible that will put the data in Col's A,B,C,D in the same format as the data in Col E. Another software I have uses the same format as Col E. I would then be able to import the data. Is there a way to do this? Appreciate all suggestions. Thanks.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | date | P1 | P2 | P3 | |||
2 | 10/05/05 | 6 | 7 | 6 | 10/05/2005;6;7;6 | ||
3 | 10/05/05 | 1 | 1 | 1 | 10/05/2005;1;1;1 | ||
4 | 10/05/05 | 0 | 2 | 1 | |||
5 | 10/05/05 | 6 | 4 | 2 | |||
6 | 10/05/05 | 5 | 4 | 4 | |||
7 | 10/05/05 | 5 | 3 | 3 | |||
8 | 10/05/05 | 3 | 3 | 7 | |||
9 | 10/05/05 | 8 | 1 | 0 | |||
10 | 10/05/05 | 4 | 2 | 3 | |||
draw |