replace some text on a string in a cell

i have this string result from a query

Camacho Mendoza MiguelAngel;#97;#Hernandez Ramos Felipe;#351;#Miguel Hernandez Nemesio;#87;#Garcia Reyes Sergio;#174;#Hernandez Tapia Ramon;#85;#Mendoza Galvez Victor;#137;#Izquierdo Munoz JoseAlfredo;#90;#Hernandez Garcia Sergio;#170

those number ";#97;#" are from the id cause is a relational table i want to quit the id from them and replace it by , or ; would be ok so the string wouldbe like this

Camacho Mendoza MiguelAngel, Hernandez Ramos Felipe, Miguel Hernandez Nemesio, Garcia Reyes Sergio, Hernandez Tapia Ramon, Mendoza Galvez Victor, Izquierdo Munoz JoseAlfredo, Hernandez Garcia Sergio

can someone help me pls

you dont need a macro try a find a replace

Find What: ;#*;#
Replace with: ,

Thanks

well ty for ur info fredlo but i want it to do it automatically cause is a book with 30 queries every query is on one dif sheet and i have a concentrated and the thing is that the user just open the excel workbook and just c the concentrated so i really would appreciate if u tell me if there is a function to look and replace on a string in vba but anyway tu for ur help fredlo

Select the cell(s) and run the code

Please Login or Register  to view this content.

Jindom Brother u r really good at this thing that work really well ty for ur help i will study the code but that work really well so happy

You are welcome.