Thread
:
tricky search and replace
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
john
external usenet poster
Posts: 11
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...
Reply With Quote
john
View Public Profile
Find all posts by john