anilsharaf
New Member
- Joined
- Apr 8, 2014
- Messages
- 41
- Office Version
- 2007
- Platform
- Windows
how should I concatenate the following. Plz show me the way. Thanks in advance. there is a long list of data. This is a sample only.
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
t1 | t2 | t3 | when concatenated it shows this | I want this |
A16 | 321043 | 001 | A16/321043/1 | A16/321043/001 |
A16 | 321043 | 011 | A16/321043/11 | A16/321043/011 |
A16 | 321043 | 123 | A16/321043/123 | A16/321043/123 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>