Text to columns error help

[zone709]

HI in column AD all of the sudden recently if I use text to columns in that column I get a pop up . There's already data here. So you want to replace it?

I have text to columns in a code and I tried displayalerts= false and true, but that doesn't help cause that will have it hit ok and the columns will shift. Is there any other way of fixing this or what can be causing this issue only in this column. Any help would be great

 

[steve the fish]

Its warning you that if you continue it will overwrite some data in the cells to the right. Get rid of that data first and it wont warn you.