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...
jim_p_1490 Removing the four right most characters of nine means you want to retain the five left most. Thus, I would suggest:
=LEFT(J1, 5)