Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Darla Morrison   on Nov 07 In MS Office Category.

  
Question Answered By: Aakifah Khan   on Nov 07

Which version of Excel are you using? 2003 will allow you to do a Find
(or a find  and Replace) across the whole workbook, clicking the 'Find
All' button will produce for you a list  (not printable) that you can
work through. But this is not necessary, you can do a find (and
replace if you want, but this replaces ALL instances of a character in
a given cell) and it will take you to the first cell  having the
offending character and allow you to edit it manually, then you can
click on 'Find Next', edit manually again, etc. etc. Excel 2000 will
only do this one sheet  at a time and does not have the 'Find All' option.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 


Tagged: