Thread: Would like to change all "yes" cells in a worksheet with "logged"
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default Would like to change all "yes" cells in a worksheet with "logged"
select an area that contains all the cells you want to replace and do

Edit=Replace

Type in Yes in the first box and Logged in the second box.

Then click replace all.

--
Regards,
Tom Ogilvy


"Kezza" wrote:

Hi all, can anyone help me to achieve this.Thanks


Reply With QuoteReply With Quote