NY2DR
10-19-2007, 11:20 AM
Hello all,
Here is my situation. I have about 5,000 rows in a column that has 10 or less characters in it. I would like to select those rows which have less than 10 characters and add three zeros in front of it to make it equal to 10
Example: 12345678L --> 012345678L 123456789Q --> STAYS THE SAME 12345H --> 000012345H 123456G --> 000123456G
Any solutions?
I was using this: =IF(LEN(A22)=7,"000"&A22,A22) But this takes too long and is tedious changing then len value every week.
Thanks
Here is my situation. I have about 5,000 rows in a column that has 10 or less characters in it. I would like to select those rows which have less than 10 characters and add three zeros in front of it to make it equal to 10
Example: 12345678L --> 012345678L 123456789Q --> STAYS THE SAME 12345H --> 000012345H 123456G --> 000123456G
Any solutions?
I was using this: =IF(LEN(A22)=7,"000"&A22,A22) But this takes too long and is tedious changing then len value every week.
Thanks