Excel: concatenate digits begining with zero and show the result with zero.


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.

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


This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of July 02, 2017.


For more resources for Microsoft Excel