Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Delete range with formatting

7 views
Skip to first unread message

Tatsujin

unread,
May 8, 2021, 4:10:02 AM5/8/21
to
I am pasting some data from a website onto my spreadsheet starting at cell A1. The data always extends 7 columns across (to Column G). The number or rows always varies from about 500 to 600 rows, but could be more, as the data size varies.

What is a good way to programatically clear away this entire blob of pasted data, and remove the formatting at the same time?

Thanks!
0 new messages