Removing text between hyphens and removing the hyphens

[sonofroy]

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

 

[Dave Peterson]

Select the range to fix
Edit|Replace
what: -bRRb- (b represents the space character
with: (leave blank)
replace all

 

[Jim Thomlinson]

=LEFT(A1, 4) & MID(A1, FIND("-", A1, 6)+1, 256)

Where your text is in cell A1

 

[Luke M]

Perhaps something like this:
=LEFT(A2,4)&MID(A2,FIND("-",A2,6)+1,999)

 

[Gary''s Student]

If the 9's are fixed in number then all you need to do is to remove a fixed
length prefix:

=MID(A1,11,256)

This assumes the R's, the dashes, and the spaces are fixed in number and
position.

 

[David Biddulph]

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

 

[sonofroy]

This just came up but what if I want to put back one hyphen to look like this?

9999 - AAAAAAAAAAAAAAA

 

[David Biddulph]

Did you try -1 instead of +1 ?
--
David Biddulph

This just came up but what if I want to put back one hyphen to look like
this?

9999 - AAAAAAAAAAAAAAA

 

[sonofroy]

That worked Perfectly Thank you!

Did you try -1 instead of +1 ?
--
David Biddulph




.