to split a cell

[natedogg]

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.

 

[timwangTM]

Try to record one macro for text to columns. Note step 3 of the wizard, you can set any of splitted columns to text. Study the macro, the format exists in the FieldInfo like Array(3, 2) where 2 indicates text format which will not remove 0.

 

[natedogg]

I will look at that, but the data comes in as text, general or something else, then when text to columns is done it seems show (dont know what is is technically called) the equation for that number in some cells. Then I reformat to number and it will turn those into numbers but the cells lose the zero in front. Can not find the perfect combination to get it all to text showing as a number.
I think there should be some better code than the text to column?