Is there a way to combine functions in excel to create something like: Concatenate(X1,X2,X3,X4) with all X1 to X4 with a (different) defined length?
So, if X1 only has 3 characters it should still be seen as e.g. 6 characters. (so 3 spaces are added at the end of X1)
to give an example: concatenate(X1;X2;X3;X4) and length 6;6;8;5
with X1=123.;X2=123;X3=123;X4=123 should result in:
123___123___123_____123__ with _ for the spaces