remove hyphons

Seamus2626
Seamus2626 used Ask the Experts™
on
I have a list of numbers like

002-248631-001

What is the formula needed to return

002248631001

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

pls try

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

Regards

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial