Hi,

Please show us a small sample of the data in the column and in the table and
explain using that what you want.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Libby" wrote:

The ID in the replacement has a leading 0
--
Libby


"Sean Timmons" wrote:

What is unique about these ID's? What needs to be changed?

"Libby" wrote:

I have a column of 3600 IDs that I need to find and replace in a table that
has 4 columns and 18000 rows. What kind of a formula that I can create to do
this.
--
Libby