Reset Password · PC & Mac Help and Assistance

Welcome Guest! To enable all features please Login or Register

Posted by: DogMan - 12 November 2023 14:45:20
I want to move the last eight characters (the postcode) to the nest column, how can I do this?

Posted by: sirclesadmin - 12 November 2023 14:47:57
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, 8) 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) - 8). 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, 8). B1 will display elloWorld. In C1 (or A1 if you want to overwrite), enter =LEFT(A1, LEN(A1) - 8). 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.

Posted by: sirclesadmin - 12 November 2023 14:47:57

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, 8) 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) - 8). 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, 8). B1 will display elloWorld. In C1 (or A1 if you want to overwrite), enter =LEFT(A1, LEN(A1) - 8). 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.

Posted by: Stuart Elliot - 05 August 2025 08:59:47
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.

Posted by: Stuart Elliot - 05 August 2025 08:59:47

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.

Important Information: