how can I delete the first 9 charactoer in every cell?

[eeehwc]

anyone can help me? thanks a lot

 

[BenjieLop]

anyone can help me? thanks a lot.

To delete the first 9 characters in a cell, use this formula

=RIGHT(A1,LEN(A1)-9


Regards

 

[eeehwc]

thanks, it work

 

[BenjieLop]

You are welcome ... thank you for the feedback.

Regards.