Urgent
 

Need formula to remove character from a string and display string in
new cell...

e.g

123/adc-123 xyz 123abc123xy

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

Urgent
 

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/

Urgent
 

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/

Urgent
 

Hi Frank



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


This is close but I need to remove one more charater...".

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

Urgent
 

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

Frank


Hi Frank



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


This is close but I need to remove one more charater..."."


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

Urgent
 

THANKS A BUNCH...That did it

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