I received an Excel file with data I need to reformat and do not know how.

1. Is there a way I can write a formula to change data from 1/13/1996 to
1131996 [no slashes]?

2. I have telephone numbers 760-123-4567 I need changed to 7601234567 [no
dashes]

3. One column has CA - California. All I need is CA How do I truncate this?

I have approximately 400 records and would appreciate anybody's help. Thank
you.