Hi Roger

Thanks, a neat and simple solultion. I must make more use of F5.

Regards

Charles

"Roger Govier" wrote:

Hi Charles

You don't actually need a script.
Select you whole range of dataF5SpecialBlankOKright clickDeleteShift
cells left.

--
Regards
Roger Govier

"Charles" wrote in message
...
I have 8000+ rows of data where each row has bank cells in random
positions,
except for Column A which is aways populated.

Can someone help me with a script that will check each row, delete the
bank
cell by moving the other cells in the row to the left.

Thanks