Question: Ive got multiple rows in a column that's 10 digits long, and need to take the 7 digits of the right and post in the next column/row beside it. Is there a way a generate this in a Macro?

```
2300056711   0056711
2311080900   1080900

```

Answer: 
Fairly simple RIGHT() function

```
=Right(A1,7)

```

[![enter image description here](https://i.stack.imgur.com/g77wc.png)](https://i.stack.imgur.com/g77wc.png)
Below formulas also retrieve the same 

1) `=MID(A1,LEN(A1)-6,LEN(A1)-(LEN(A1)-7))`

2) `=SUBSTITUTE(A1,LEFT(A1,(LEN(A1)-7)),"")`

**OP**

[![enter image description here](https://i.stack.imgur.com/nW4ye.jpg)](https://i.stack.imgur.com/nW4ye.jpg)