charles wrote...
....
. . . For example branch code
800 on the list equals branch code C001 in the system. I need to get a way in
excel to convert all the branch codes that are next to the employees to the
code I have currently in our system. Is there a way in Excel to "translate"
the existing (non-system recognized) codes into the ones that they euate to
in the system? . . .
....

Use VLOOKUP. You'd need to create a cross-reference table of branch
codes consisting of two columns, the first containing the branch codes
used in your spreadsheet and the second containing the corresponding
branch codes used in the target system. I'll assume that table is in
X1:Y200. Easier if you insert a column in your list between other
fields and the branch code field. Then for each branch code in your
list (I'll assume the topmost one is in cell A5), use a formula like
the following in the inserted column.

=VLOOKUP(A5,$X$1:$Y$200,2,0)

Fill this formula so that there's one such formula for each record in
your list, then export the range containing the other fields and this
column of formulas to the target system.