Deleting or Adding Zeros

I have two lists in CSV format that I need to join tables in Access.

One list, which is too large to open in Excel has no zeros at the end
or a letter. The other list has zeros or a letter.

How can I add zeros to one list or delete zeros from the other list?

100-01-001P
100-01-001R
100-01-001S
100-01-002 (The other list has this number: 100-01-0020)
100-01-003A
100-01-004 (The other list has this number: 100-01-0040)
100-01-005 (Etc.....)
100-01-008
100-01-009
100-01-010
100-01-020E
100-01-020F
100-01-020G
100-01-020H
100-01-021

For this example, I'm going to assume that you want to add a zero only if
the length of the data in the cell is 10.

Let's say your data is in Column A.
In B1, enter the following:
=IF(LEN(A1)=10,A1&"0",A1)

Copy this through column B as needed.

This will ONLY work if your naming conventions remains as shown below (with
what appears to be a max of 11 characters).

Have a great day!
Barb Reinhardt

"Raquel666" <sixsixsixismoney@yahoo.com> wrote in message
news:1109181450.437320.175440@z14g2000cwz.googlegroups.com...
>I have two lists in CSV format that I need to join tables in Access.
>
> One list, which is too large to open in Excel has no zeros at the end
> or a letter. The other list has zeros or a letter.
>
> How can I add zeros to one list or delete zeros from the other list?
>
> 100-01-001P
> 100-01-001R
> 100-01-001S
> 100-01-002 (The other list has this number: 100-01-0020)
> 100-01-003A
> 100-01-004 (The other list has this number: 100-01-0040)
> 100-01-005 (Etc.....)
> 100-01-008
> 100-01-009
> 100-01-010
> 100-01-020E
> 100-01-020F
> 100-01-020G
> 100-01-020H
> 100-01-021
>