I have a worksheet, with imported text. I would like to be able to do a find and search for the text in "A1". Locate the text as described, then be able to clear the columns of text in columns "B" thru "F". The "HTML" does show the special character, before PAGE, it is the box [] character. Any suggestions, or help would be appreciated.
MrEXCEL-Xample.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | PAGE | 2 | 18:00 | 8:46 | 02M | AR2004 | ||
2 | RPTDATE | DRIVER.. | DFM | DTO | LMILES | OMILES | ||
3 | ||||||||
4 | 2/12/2004 | FARRAT | LAX | SAC | 378 | 0 | ||
5 | SAC | RNO | 155 | 0 | ||||
6 | ||||||||
7 | ||||||||
8 | 2/9/2004 | BISHOR | RNO | SRO | 239 | 0 | ||
9 | SRO | RNO | 239 | 0 | ||||
Sheet1 |