Try
=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")

--
Regards
Roger Govier
"aducutlas " wrote in message
...
Need formula to remove character from a string and display string in a
new cell...

e.g

123/adc-123 xyz 123abc123xyz


---
Message posted from http://www.ExcelForum.com/