Substitute

How I can change in cell B1, value of the A1 cell in a sample like bellow:

from A1 3355789 to B1 35789

Hi,

Try this formula in B1

=RIGHT(A1,5)

Hope this helps

Helps 100% Mucho Thanks

Helps 100% Mucho Thanks