A & B & C & D
Hello!
I have next cells:
A B C D
101 1 3
With =A1 & C1 & D1, I obtained 10113.
However, I need to intercalate one string type 001, 002...
between cells.
Example:
A B C D
101 001 1 3
(Where 001 is formated with Custom to have 3 digits.
I would like to obtain 10100113.)
1 - How is possible to do this, please?
2 - The result is possible to format as number, please?
Thanks in advence.
an
|