Deleting or Adding Zeros

  • Thread starter Thread starter Raquel666
  • Start date Start date
R

Raquel666

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
 
Back
Top