Forum Discussion

jim_p_1490's avatar
jim_p_1490
Copper Contributor
Mar 07, 2020

I need to remove 4 digits in a file

Hi All, Im working with EXCEL spreadsheets and have address and numerical data in a column, there is zip code data in column J that represents 9 digits and the column has upwards to 20K lines. I nee...
excel
Abiola1's avatar
Abiola1
MVP
Mar 07, 2020
Hello,

=RIGHT(J2,4)

Copy down the formula
jim_p_1490's avatar
jim_p_1490
Copper Contributor
Mar 07, 2020

Thank you Abiola1 

It didnt work 

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Mar 08, 2020
    If your codes are numbers rather than text then you could use this =LEFT(TEXT(A1,"General"),5)

    You should also check out the Get Data (Power Query) functionality of Excel. It's perfect for this sort of data clean up

Resources