View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Find / Replace in a string

Why not just type in

=IF(ISBLANK(*),"N/A", "(*-(*-*))/*")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Basu" wrote in message
oups.com...
Hi All,

I need a help with a find/replace that I have been trying to accomplish
for sometime now. I have a formula for eg.
IF(ISBLANK(AS45),"N/A",(AS45-(AU45-AV45))/AS45). What I need to do is
replace all the cell references with a "*". So the output would be
IF(ISBLANK(*),"N/A", (*-(*-*))/*).

Any help in this direction will be highly appreciated.

Regards.