View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
john john is offline
external usenet poster
 
Posts: 11
Default tricky search and replace

replace XXXX with this

=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-2,3)


ok, that woirks on an individual basis, but search and replace doesn't like
it. looks like I'll have to go the macro route...