in mcrosoft excel how do i convert 04-00-00-00 to 04 00 00 00
basically replace the dash with spaces

Hi tych2nel,

1) Highlight the columns (or rows) you want to fix.

2) Click Edit / Replace

3) Find what?: - (hit the dash key)

4) Replace with?: hit the space bar

5) Select Search by Columns (or Rows)

6) Replace *All*

Additional Link of Interest:

Excel Tips, Tricks, Formula & Functions and General Usage:
http://www.ozgrid.com/Excel/default.htm

That should do it - I tried it out and it worked perfectly for me. If
you have any questions, please post a clarification request before
closing/rating my answer and I'll be happy to reply. I'm sorry it took
so long to post this but my computer has not been cooperating.

Thank you,
hummer

OMG Thank You so much, how about vice versa eg. 004 00 00 00  to 004-00-00-00

Replace [Tap once on your space bar to create a SPACE] with "-"

Thank You for your  Help!!

Thank you for your thank you and nice rating, tych2nel. To do the
reverse, just switch steps 3 & 4:

2) Ctrl+H (Replace)

3) Find what?: hit the space bar

4) Replace with?: - (hit the dash key)

Regards, hummer

Hi tych2nel-ga 

You could use an actual Excel function, Substitute.

=Substitute(A1,"-"," ") [assuming your string is in cell A1] will
replace all the -'s with spaces.

To replace just the first instance of a dash you would use it like so:

=Substitute(A1,"-"," ",1).