Home » Forums » Open Source Learning Center » Question and Answer

Substitute

Submitted by Kalop on 18 August, 2013 - 21:05

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

from A1 3355789 to B1 35789

‹ How to return a range object that is just the first colmn of a named range covering multiple columns? Need help for the array formula ›
»

Hi,

Submitted by Jon on 18 August, 2013 - 22:05.

Try this formula in B1

=RIGHT(A1,5)

Hope this helps

»

Helps 100% Mucho Thanks

Submitted by Kalop on 19 August, 2013 - 00:25.

Helps 100% Mucho Thanks

»