Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to put number 18 between 602 and 0100380.
number 1 | number 2 |
---|---|
6020100380 | 602180100380 |
Note: This post was edited by a Community Moderator to include English translation as a courtesy.
Hi Surawut,
if you handle the field as text you can do it, if the position is allways the same, then try this:
=num(left(number1,3)&'18'&right(number1,7))
G.