I want to move the last eight characters (the postcode) to the nest column, how can I do this?

---

To move the last eight characters of one cell to the next cell in Excel, you can use a combination of Excel functions. Here's a step-by-step guide:

Extract the Last Eight Characters:
Use the RIGHT function to extract the last eight characters from a cell.
If your data is in cell A1, you would use =RIGHT(A1, 😎 in the cell where you want these characters to appear (say B1).
Remove the Last Eight Characters from the Original Cell:

To remove the last eight characters from the original cell, you can use the LEFT and LEN functions.
In a new cell (or if you want to overwrite the original cell, ensure you've copied the data first), use =LEFT(A1, LEN(A1) - 😎. This formula takes the length of the string in A1, subtracts 8, and then keeps everything to the left of that new length.
Drag the Formulas Down:

If you have a list of cells where you need to perform this operation, you can drag the formulas down. The cell references will adjust automatically.
Copy and Paste as Values (Optional):

If you need the results to be static (not formulas), you can copy the cells with the formulas and paste them as values.
Here's an example:

Original value in A1: HelloWorld
In B1, enter =RIGHT(A1, 😎. B1 will display elloWorld.
In C1 (or A1 if you want to overwrite), enter =LEFT(A1, LEN(A1) - 😎. C1 will display He.
Remember, if you overwrite the original data in A1 with the formula, you'll lose the original data. It's often a good practice to work on a copy of your data to prevent accidental data loss.

---

Let’s say your full address is in Column A, starting in cell A1.

In Column B, type this formula:

sql
Copy
Edit
=RIGHT(A1, 8)
That will pull out the last 8 characters from the text in A1 — which should be your postcode.

Now, if you want to remove those last 8 characters from Column A (so it just shows the street address), use this formula in another column (like C1):

sql
Copy
Edit
=LEFT(A1, LEN(A1)-8)
Once everything looks good, you can copy the new columns and paste them as values (Right-click → Paste Special → Values), so they’re no longer formulas.

After that, you can delete the original column if you don’t need it anymore.