if Cell is "FL Broward"=Broward else Cell "FL Miami"=Dade

[Excell text convert in same cell]

I am tring to make my Excel sheet convert name/txt base on condition

if cell B2= FL Broward result Broward
else Cell B2 = FL Miami resut Dade
else cell b2 = West Palm Beach result Palm Beach

 

[Bob Phillips]

In a separate cell? If so then just use a simple formula

=IF(B2="FL Broward","Broward",IF(B2="FL Miami","Dade","Palm Beach"))

--
HTH

Bob Phillips

"Excell text convert in same cell" <Excell text convert in same
(e-mail address removed)> wrote in message
news:[email protected]...