tezza73
asked on
How do you concatenate numbers in the customised form
Hi Experts
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:
9800158671 0001
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.
Regards
Tezza
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:
9800158671 0001
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.
Regards
Tezza
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi teylyn
Spot On, thanks for that it worked a treat. Top Marks.
Regards
Tezza
Spot On, thanks for that it worked a treat. Top Marks.
Regards
Tezza
ASKER
thank you very much, a quick and accurate answer.
Thanks for the grade, Tezza!
Instead of the text to columns and concatenation and all that, you could use
=SUBSTITUTE(C2," ","")
Copy down, then copy the results and use Paste Special > Values into a different column or into the original formula cells.
cheers, teylyn