View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default delete text in a cell using certian criteria

I have a column with various data in it
How do I delete all the data to the left or right of a certain criteria in
this case a €œ-€œ. The data is not aligned so text to columns doesnt work