I am a bit new with regards to excel but If have a column of data that has
values in this format (note the placement of the hyphens)

9999- RR - AAAAAAAAAA

The length of 9's are constant at 4
The length of A's can change between cells

I would like to remove the R's and hypens to have this:

9999 AAAAAAAAAAA

Any suggestions? Thanks for your help