Find and replace dilemma
101001 011685
"Rick Rothstein" wrote:
How different are the old numbers from the new ones? I'm worried about the
possibility of changing a number and then later on thinking that new number
was an old one. Can you post a sample of each?
--
Rick (MVP - Excel)
"mismose" wrote in message
...
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
|