I need to merge different columns like:
AB 0054 00000137
I do it this way
It works but my Zeroes get lost.
The text in my columns has been formatted in "personal" with zeroes before what's contained in the cell. If I change cell to text or numeric I lose zeroes.