i can split a column of cells right after the 9th digit by using text to columns. which i can insert that code in a macro i need to run. when i choose text to columns, i need my data to remain text, which some numbers start with a zero. those get deleted. then having to reformat the column to text, seems different sources of data are not turning to text when, i dont know but does anyone have an efficient piece of code laying around that will take the digits after the 9th and delete those or placing on next column or something.