How do you concatenate numbers in the customised form
I don't know if it is me being senseless, probably is, but I would like to concatenate two columns.
In cell C2 I have a Number thus:
I want to remove the BLANK space and make it one number thus 98001586710001
First I split using "TEXT TO COLUMNS" and ended up with
9800158671 in CELL D2 and a single 1 in CELL E2
I then customised CELL E2 to make it a four digit number 0001
Then I concantenated CELL D2 & CELL E2 and ended up with 98001586711
I realise that CONCATENATION is "textual" but how can I end up with the desired result please.
Thanks in advance.