Thread: Deleting partial information from all cells in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Deleting partial information from all cells in a column
Edit|Replace?

Smooney wrote:

I have a column containing serial numbers but some of those numbers have an
'S' in front of them. Is there a way to delete the 'S' from all the cells
but leave the number there?

--

Dave Peterson
Reply With QuoteReply With Quote