Repeat action to all columns

[cny]

Dear All...i need to actual clear cell that has #N/A next to it. i'd tried looking up every where but i couldn't find a solution.
Thus, i use another way of approaching by cutting and paste cell contains #N/A to the right cell of it.
However i came to a cross road as it only applies to column A and on the rest of cells that contains #N/A.
Attached is the sample of file which only consists couple of columns. The actual file has 100's of them.
Really need help on this matter.
Thank you.

Please Login or Register  to view this content.

[Kaper]

do you want to have #NA left in next column or both columns empty? I assume the second option. So try:

Please Login or Register  to view this content.

[cny]

Hi Kaper....Yes...it's the second option.
thank you so much! :-)
Btw, do you have idea on how to sort them?
Sorry...just notice that it needs sorting.
Many thanks.

[Kaper]

sorting will remove empty rows. But you probably accept it. If sorting shall be on score rather than teamname use Cells(1, i+1) as key1 and if descending - use order1 xldescending

Please Login or Register  to view this content.

[cny]

Hi Kaper...thanks. Works like a charm!
Appreciate it, man! Have a great day