Hello,
I need to combine columns to create an 18 digit code.
Col A
00001
00012
00005
00001
00001
Col B
4444
4444
333
333
22
Col C
_
_
_
_
_
Col D
AAAAA
BBBB
CCC
DD
AAAAA
Col E
020
014
064
014
014
So, currently Col A1+B1+C1+D1+E1 = 000014444_AAAAA020 - length being 18
And now A4+B4+C4+D4+E4 = 00001333_DD014 HOWEVER length is only 14 which is wrong. The string text needs to read 00001333__DD___014
So, the formula I need is to make my concat = an 18 character length and the way the string text needs to read is
Col A 00001 + Col B 4444 OR 333_(1 underscore) OR 22__ (2 underscores) + Col C _ + Col D AAAAA or CCC_ (1 underscore) or DD___ (3 underscores) + Col E 3 digit number.
So Col A = 5 characters. Col B = 4 characters. Col C = 1 characters. Col D = 5 characters. Col E = 3 characters.
So, if Col B does not have 4 characters I need an _ to be added to make that number move to 4, and the same with Col D, if the characters are not 5 then I need underscores added at the end of the text to make the text more to 5.
Any help is massively appreciated.
Apologies for formatting, tired to explain as best I can
Bookmarks