View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob C[_3_] Bob C[_3_] is offline
external usenet poster
 
Posts: 5
Default Using Find & Replace in macro

Hi Everyone

I have a speadsheet with columns of credit card
transactions.
Column B contains the name & address of the retailers as
show below:

FOODLAND PARKLAND PAR
SAMS SEAFOOD RICHMOND PAR
SHELL SELF SERVE ELIZABETH VLE
DICK SMITH W8080 ELIZABETH CIT

How do I Find and Replace all instances of PAR on the
right hand end of cell with PARK without changing
PARKLAND to PARKKLAND with two "K's" ?.

TIA

Bob C