Sorry, I probably don't explain things well with a keyboard.

In column 'A' there is a formula: =CONCATENATE(J2,K2) The result of this should be: S-3314PH4TAB-MOT-M-1A-201 But instead I get: S-3314PH4TAB-MOT-M-1A-20

Col J = S-3314PH4TAB-MOT-
Col K = M-1A-201

I know I could fix this after. But How do I avoid this?


Mike