How do I ask Excel to take the....

[tim :/]

....last 4 digits from a column of text and copy them into a new column?

I have a report with about 3000 cells in a column. In each cell is an
address and the last 4 digits is the post code. I want to run a formula that
will automatically take these last four digits and cut or copy them into a
adjacent column...

Many thanks all,

Tim.

 

[JE McGimpsey]

One way:

B1: =RIGHT(A1,4)

 

[Guest]

You could use the "RIGHT" function and which will allow use to view the last
4 digits, if you need them as a value, you would have to "cut and paste
special-values" to the next column.
Hope this helps
Sue

 

[tim :/]

...last 4 digits from a column of text and copy them into a new column?

I have a report with about 3000 cells in a column. In each cell is an
address and the last 4 digits is the post code. I want to run a formula
that will automatically take these last four digits and cut or copy them
into a adjacent column...

Many thanks all,

Tim.

Perfect, thanks for the prompt response!

 

[Phil]

If you don't want to use Paste Special, you could include the =VALUE
function within the formula to convert the data to numbers, eg

=VALUE(RIGHT(A1,4))

HTH

Phil

 

[Guest]

That's good to know!

If you don't want to use Paste Special, you could include the =VALUE
function within the formula to convert the data to numbers, eg

=VALUE(RIGHT(A1,4))

HTH

Phil