vzachin
10-29-2006, 07:49 PM
hi,
I have a file that I copied & pasted from a WORD doc. I need to do a text to column but there are "Header" rows that I need to delete. These "Headers" most often are defined names. The data that I want to text to column always has leading spaces.
I tried to do an AutoFilter but I can't get it to work correctly. I cannot sort and delete the headers because I need to retain the original format of the data.
Any suggestions?
thanks
zach
I have a file that I copied & pasted from a WORD doc. I need to do a text to column but there are "Header" rows that I need to delete. These "Headers" most often are defined names. The data that I want to text to column always has leading spaces.
I tried to do an AutoFilter but I can't get it to work correctly. I cannot sort and delete the headers because I need to retain the original format of the data.
Any suggestions?
thanks
zach