I want copy the cell with 20 numbers and letters to another cell but only with first 16 numbers and letters. example: the cell contains

Assuming your 20 character string is in A1, then put this in B1: =LEFT(A1,16) Hope this helps. Pete

Yes. It works. It save me lots of time to modify the work sheet Thank you

You're welcome - thanks for feeding back. Pete ly uoted text -

Can you tell me how to do the same thing from the right side? I tried =RIGHT(A1, ), but not sure what else to put in the parenthesis.

Starting on the right, just count the number of characters you want to copy. Since you had 20 total and you already copied 16, I'll assume you now want to copy the last 4, so: =RIGHT(a1,4)