Deleting partial cell data?

[Nan]

I have a column that contains various codes. Each code begins with "SG
followed by between 5 and 7 numbers. Is there a way to delete the S
from each of the codes so I am left with just numbers?

Thanks for any ideas.
Na

 

[Dave R.]

Select range, press CTRL H, enter SG in "find" and leave "replace" blank,
then replace all.

 

[Frank Kabel]

Hi
you could use 'Edit - Replace' for this

 

[Nan]

Thank you! :