Hi, this may be super easy for somebody on here.
I have 3x columns I want to combine to form a NI number
AB23 09 36C the result I want is AB230936C, basically combine what I am seeing in each cell.
However when I use the concatenate function, the result is AB23936C. The leading zero in my custom format for 2 digit numbers in the middle cell is ignored.
e.g.
AB23 09 36C AB23936C
AB27 04 54C AB27454C
Why is it so hard to combine cells?