Concatenate 5 cells into a single But including front zeroes or all zeros, e.i 000

Hi,

Need some help, might someone tell me a snipped to add to the code?

Im trying to concatenate 5 cells from Range R22:V22 to Single cell DU22 but adding a dash between.

The VBA code it does the job as long the string are single number with front zero, now i need to do the same but this time there are five cells and each one include 3 digits, Example : 000 001 010 121 110

When are three positive digits is not a problem, but when such digits Include leading zero it wont concatenate correct.
When I place the Formula - Concat(R22:V22) in Cell DU22 and DU23 as well, it won't display the leading zeroes at front or if the string is triple zero it just display single zero.

Example:
--->>>C O L U M N S
______R___S___T____U___V__
Row
22___010_000_010_112_212 -> DU22 ->Display --> 10-0-10-112-212
23___000_120_100_120_121 -> DU23 ->Display --> 0-120-100-120-121

This is the code I'm Using:

Please Login or Register  to view this content.

Thanks !!!

If you don't want front zeroes to vanish, you need to format the digits with Format function.

Please Login or Register  to view this content.

Hi Crooza,

No is displaying the same ...

Example:
--->>>C O L U M N S
______R___S___T____U___V__
Row
22___010_000_010_112_212 -> DU22 ->Display --> 10-0-10-112-212

Hi Yujin,

Is the same output my friend..

Example:
--->>>C O L U M N S
______R___S___T____U___V__
Row
22___010_000_010_112_212 -> DU22 ->Display --> 10-0-10-112-212

Hi Jujin,

Contrary, I need the Front zeros and or all zeros (if in cell contents)

the first thing i did was the formatting 000-000-000-000-000

Try this

Please Login or Register  to view this content.

Hi,

Yes is working!!

the Call function was ConCatAll=

Excel cell had ConCatal (from previous code tested)

Thank you all !!

Crooza, Yujin, Jolivanes and sktneer !!

Regards