Clear contents of column(L) after every one row

hi,
i have data in column(L) range L6:L500
i want clear contents of every second row
for example
L6 = 2
L7 = 2
L8 = 2
L9 = 2
L10 = 2
L11 = 2
Now result should be like below

L6 = 2
L7 = (CLEAR CONTENTS)
L8 = 2
L9 = (CLEAR CONTENTS)
L10 = 2
L11 = (CLEAR CONTENTS) And so on


thank you

May be

Please Login or Register  to view this content.

Perfect YaseerKhalil

thank you very much

You're welcome. Glad I can offer some help for you

I have just one little question
is it possible to do like this

L6 = 2
L7 = 2
L8 = 2
L9 = 2
L10 = 2
L11 = 2
Now result should be like below

L6 = (CLEAR CONTENTS)
L7 = 2
L8 = (CLEAR CONTENTS)
L9 = 2
L10 = (CLEAR CONTENTS)
L11 = 2
L12 = (CLEAR CONTENTS) And so on

Capture.JPG

Thank you Jindon Sir