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 : "Medell¡"
As you noticed, de "í" is replaced by "¡" so i need a formula that replace it taking into account that there are other cities as:
"Chía" that are written as : "Ch¡a" again "¡" replacing "í".
So i need a solution that replace "¡" for "í " no matter what is before and after the "¡" .
So the formula or the process would have to do the following;
Ch¡a -->Chía
Medell¡n --> Medellín
The solution has to be with out VB. i´m new using excel so probably the solution is very easy.
Thank you all !
Hi David,
You may try
=SUBSTITUTE(<text>,"¡","i")
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 (á)David, as variant you may use nested SUBSTITUTE
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(<you text>,"£","ú"),"¡","í"),"Â","á")
