How I can change in cell B1, value of the A1 cell in a sample lik bellow: from A1 3355789 to B1 3578
K Kalop Aug 18, 2013 #1 How I can change in cell B1, value of the A1 cell in a sample lik bellow: from A1 3355789 to B1 3578
C Claus Busch Aug 19, 2013 #2 Hi, Am Sun, 18 Aug 2013 21:44:31 +0100 schrieb Kalop: from A1 3355789 to B1 35789 Click to expand... is your sample correct? Then try: =--(MID(A1,2,2)&RIGHT(A1,3)) Regards Claus B.
Hi, Am Sun, 18 Aug 2013 21:44:31 +0100 schrieb Kalop: from A1 3355789 to B1 35789 Click to expand... is your sample correct? Then try: =--(MID(A1,2,2)&RIGHT(A1,3)) Regards Claus B.
S Stan Brown Aug 20, 2013 #3 How I can change in cell B1, value of the A1 cell in a sample like bellow: from A1 3355789 to B1 35789 Click to expand... See the MOD function.
How I can change in cell B1, value of the A1 cell in a sample like bellow: from A1 3355789 to B1 35789 Click to expand... See the MOD function.
