View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mismose mismose is offline
external usenet poster
 
Posts: 4
Default Find and replace dilemma

recently when we converted to a new financial management program all of our
740 position numbers were changed by the automated system I have a list of
the new numbers and a list of the old numbers. All of my data in spreadsheets
contain the old position numbers. My question is... can I use find and
replace to fix this using several columns without having to do it individually
ie: find everything in this column and replace with this column
"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