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...
As variant
Data->Text to Columns->Fixed width->Create break on second step->Select Text or General, depends on needs, on third step->Finish
Select new column K -> Del