Forum Discussion
SEARCH and REPLACE
Hi !
I have a database and some characters are switched with combinations between other characters and symbols. For example:
"Medellín" , that is a Colombian city, is written as : "Medel...
Hi David,
You may try
=SUBSTITUTE(<text>,"¡","i")
I works. thak you so much. Now i have an other issue. in my database i not only have the chage:
"Medellín" , written as : "Medell¡" or
"Chía" that are written as : "Ch¡a"
i also have:
"Bogotá" written as "BogotÂ"
and
"Cúcuta" written as "C£cuta"
All of them are in the same column so how can i make a formula that replace:
"¡" for "í"
"Â" for "á"
"£" for "ú"
something like: if this(¡) appears make the replace with this(í) and if this other (Â)appears make replace with this other (á)
"Medellín" , written as : "Medell¡" or
"Chía" that are written as : "Ch¡a"
i also have:
"Bogotá" written as "BogotÂ"
and
"Cúcuta" written as "C£cuta"
All of them are in the same column so how can i make a formula that replace:
"¡" for "í"
"Â" for "á"
"£" for "ú"
something like: if this(¡) appears make the replace with this(í) and if this other (Â)appears make replace with this other (á)
David, as variant you may use nested SUBSTITUTE
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(<you text>,"£","ú"),"¡","í"),"Â","á")
- You are the best ! thak you again!! i appreciate that.
