Find and Replace in excel

[Chris Ashdown]

I have a column with data showing 1!6566 and i want to replace it with just the data after the ! sign I thought i could do it with 1!* but this does not work it just places a * as a replacement

 

[Newchodge]

Can't you just replace 1! with nothing?

 

[SERC1204]

=RIGHT(cell,4)

 

[Chris Ashdown]

Thanks that works fine cyndy