Provide a layout of your problem here. Have you tried datatext to columns?
I could send you Shanes email but he may ?? not want it published here. Send
me your workbook to the address below or send me a personal request for his
email.

--
Don Guillett
SalesAid Software

"YP" wrote in message
...
I have a table that is created by copying and pasting text from a pdf file.
The problem isthat when the text is pasted into excell it does not
recoginzed
the missing data in somr rows so everthing is aligend in column A. I do a
filter to identify what rows need to be moved to the right 5 cells. I
need
to cut only the visible cells with data in cells A-K and paste it in cells
F-P. Every time I try it I get an error that the function cannot be done.
Please help me, is there a macro I can create or a formula I can paste.

Thanks,