One way:

B1: =RIGHT(A1,4)

In article ,
"tim :/" wrote:

...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.