If you have two '' in a cell Len will count 1.
What do you do then?


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Rob" wrote in message ...
Hi,
I'm trying to loop through cells in column A (say rows 1 to 500) and if the length of contents is 0, clear contents as there will
be apostrophes in the cells. If on the other hand the length of contents is greater than 0, I want to place the contents from
column A in column C of the same row, whilst removing the contents of column A.

I've tried various pieces of code but run into Debug mode!

Thanks, Rob