find & replace question

J

Jim

I have a spreadsheet that, at the bottom of each page, someone has manually
numbered the page, but has called it "Sheet A" or "Sheet 1" (without the
quotes)., The pages range from the aforementioned "Sheet A" thought "Sheet
42" and there can be sheets such as "Sheet 15c" too. Can anyone suggest a
good find and replace method (or any other method, for that matter) wheein I
can delete all the Sheet references entirely?

TIA,

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to bulk add section breaks after a particular combination of letters/numbers 0
Some pages of publisher do not get printed with MS PDF 1
MS Word List Bug 0
Word macro that can call cells out of Excel for a find and replace 0
Custom Reporting Across Sheets 1
Conditional Formatting to Compare Two Sheets of Data 1
How can I find paragraph breaks that are not preceded by a period? 0
Find and Replace 6

Top