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

**AndyJr** · 01-22-2018, 12:24 AM

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

**Crooza** · 01-22-2018, 12:45 AM

Originally Posted by AndyJr

Hi Crooza,

No is displaying the same ...
(

Not on my example

see attached

**AndyJr** · 01-22-2018, 01:22 AM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenate not including all Zeros in 4digit custom format

[SOLVED] Averages of nonconsecutive cells including zeros.

Formatting cells to show precision as typed in (including trailing zeroes)

calculating average in cells, not including zeros

[SOLVED] Adding a specified amount of zeroes in front of a number

Missing zeros (including all trailing and inbetween zeros)

[SOLVED] insert zeros in front of cells already filled with data.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions