First on column C type
=right(b1,len(a1))
Then copy paste special values and Ok will remove the formulas
Now you can cut and paste it over column B

However If the exact numbers on column A need to be replaced in column B
for instance in the example provided column A first row =19 and
corresponding value in column B also begins with 19 then
on column C type
=substitute(b1,a1,"")


wrote in message
oups.com...
Hello -

I have an Excel spreadsheet that has 2 columns with many rows of
numeric data in them. The cells have been defined as text fields.

The problem I am having is I need to see if there is a way to express
the RIGHT_worksheet_function with some sort of dynamic variable. I
have a 5 digit number in many different rows of a particular column,
and need to remove the first 2 numbers in it so that the last 3 numbers
are all that is left in the field. The problem I am having is trying
to figure out how to do this without having to manually do it.

For example I have:

A B
19 19010
20 20010
21 21010
***NOTE*** Column A is already defined and only being used for example
purposes.

And so on...

Is there any way to make the expression work for column B without
having to change the expression's first 2 digits every time that
changes? Right now I have only been able to get "=RIGHT(19010,3)" to
work, but this will not longer work once the first 2 digits change in
the number. I need to figure out if there is a way to make this
formula dynamic for varying numbers.

The end result needs to be:

A B
19 010
20 010
21 010
***NOTE*** Column A is already defined and only being used for example
purposes.

Much thanks in advance...