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)

In article <435e088c$1@news.rivernet.com.au>,
"tim :/" <tim@timland.com> 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.

[Sue]

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 :/" 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.
>
>
>

[tim :/]

"tim :/" <tim@timland.com> wrote in message
news:435e088c$1@news.rivernet.com.au...
> ...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

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.

[Sue]

That's good to know!

"Phil" wrote:

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