Move a part of a cell to another cell

Example
A1=283723

I need the last 2 characters in
A2=23
this i can get with the formula =RIGHT(A1,2), and i will get A1=283723 and A2=23
But my goal is A1=287 and A2 = 23 (a part of the cell a1 has disappeared).

Is it doable ? maybe some paste option?

THanks

Originally Posted by sura

Example
A1=283723

I need the last 2 characters in
A2=23
this i can get with the formula =RIGHT(A2,2), and i will get A1=283723 and A2=23
But my goal is A1=287 and A2 = 23 (a part of the cell a1 has disappeared).

Is it doable ? maybe some paste option?

THanks

Hi,

insert a new column B and put =Left(A2,3) and =Right(A2,2) (in B2 and C2) and formula fill these as far as required.

Then select columns B & C and Copy
then Paste Special = Values back over themselves.

Delete column A.

hth
---

Originally Posted by sura

Hey thank you for a so fast reply

Unfortunately I'm afraid i don't understand your answer. Would you mind explaining it again?


"Left(A2,3) and =Right(A2,2)" Don't you mean Left(A1;3) and Right(A1"2)?

Doing it as you said would get me 23 in both B2 C2

then about the special paste window, where do u see on it the option "Values back over themselves." and where do i paste exactly?

Thanks

aaha - I (mis-)read the "and A2 = 23 (a part of the cell a1 has disappeared)." as being a formula for Row 2, but instead you want to split A1 over A1 and A2

in A2 put =Left(A1,3)
in A3 put =Right(A1,2)

copy A2:A3 and Paste Special - select Values.

(it should paste back over the formula)

delete cell A1 (shift cells up)

(but if this is just a single cell why not just edit the two cells?)

---