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:
Hope this helps.
Yes. It works. It save me lots of time to modify the work sheet
You're welcome - thanks for feeding back.
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)