View original (French)

Remove the first two characters from my entire column

Solved
stpierreliane Posted messages 15 Status Membre -  
 k -
Hello,

I would like to remove the first two characters from my entire column...
How can I do that?

Thank you in advance

2 réponses

Réponse 1 / 2
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello

Assuming the column to be processed is column A
B1=RIGHT(A1,LEN(A1)-2)
to drag down

Best regards
24
k
 
perfect!!!
0