Formatting Problem

[EMurphy]

I have a question on a specific problem I am having with formatting in excel. I have couple hundred excel cells that are formatted like example DVAT-PIC1-07-06-01. How can I change them to DVATPIC1070601 without having to do it manually? Any help would be great. Thanks.

 

[Andy Nguyen]

Assume that is in cell A1, then type this in another cell
=SUBSTITUTE(A1,"-","")

 

[Urszula]

That shouldn't be difficult.
Highlight the column you want to convert. Select Find "-" and Replace by an empty cell. And then Replace All. Hope that helps.

 

[EMurphy]

Thanks

Well that was easy to do. Thanks for the help.