There's no mass find and replace command in Excel which will do what you
want. If it were me, I would do the following:

1. Insert a blank column next to your position number.
2. Do a Vlookup to get the new number from the old number.
3. Copy the new column, Paste Special, Values.
4. Delete old column.

Regards,
Fred.

"mismose" wrote in message
...

recently we converted to a new financial system. The new system changed
all
of our position numbers (740) to an automated number. All of my
spreadsheets
contain the old position number. i have a column with the old number and
a
column with the new number. My question is..is there a way i can mass
find
and replace per spreadsheet or will it have to be done individually
"Shane Devenshire" wrote:

Hi,

We need more detail to answer this question.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mismose" wrote:

Does anyone know if there is any way to find a replace a column of
numbers
without having to do it individually?
Thanks