Hi
try the following
=SUBSTITUTE(A1,"-","")
A1 stores your sorce text. The above removew the '-' from your text
HTH
Frank

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/