A
aducutlas
Need formula to remove character from a string and display string in
new cell...
e.g
123/adc-123 xyz 123abc123xy
new cell...
e.g
123/adc-123 xyz 123abc123xy
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Try
=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")
=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")
F
Frank Kabel
Hi
try the following
=SUBSTITUTE(A1,"-","")
A1 stores your sorce text. The above removew the '-' from your text
HTH
Frank
try the following
=SUBSTITUTE(A1,"-","")
A1 stores your sorce text. The above removew the '-' from your text
HTH
Frank
A
aducutlas
Hi Frank
=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")
This is close but I need to remove one more charater...".
=SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-","")
This is close but I need to remove one more charater...".
F
Frank Kabel
Try
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-",""),".","")
Frank
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"-",""),".","")
Frank
A
aducutlas
THANKS A BUNCH...That did it