Try this
=SUBSTITUTE(A1,"abc","#")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Thursday, July 21, 2011 8:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ ***Formula for find and replace***
Hi F
Hey Prabhu,
try this formula
=IF(ISERROR(REPLACE(A1,FIND("ABC",A1),3,"#")),A1,(REPLACE(A1,FIND("ABC",A1),3,"#")))
On Thu, Jul 21, 2011 at 8:50 PM, Prabhu wrote:
> Hi Friends,
>
> Can you help me to know the formula for find and replace.Examble i need to
> find "ABC in the A1 cell and rep
Hi Friends,
Can you help me to know the formula for find and replace.Examble i need to
find "ABC in the A1 cell and replace with "#". If there is no 'ABC"
existing A1 should remain as it is.
Existing CellReplace as
12ABC 12# 13XTZ 13XTZ
--
--
