Deleting partial cell data?

  • Thread starter Thread starter Nan
  • Start date Start date
N

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
 
Select range, press CTRL H, enter SG in "find" and leave "replace" blank,
then replace all.
 
Back
Top