Forum Discussion
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...
Thank you Abiola1
It didnt work
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
You should also check out the Get Data (Power Query) functionality of Excel. It's perfect for this sort of data clean up