View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JanetP JanetP is offline
external usenet poster
 
Posts: 2
Default Globally deleting part of the information in a cell

I have many rows of data. In several cells, the end of the data in the cell
ends with a period, some numbers and an x. So the information to be deleted
would like something like .035x where 035 could be any number. Since there
is other data in any given cell, I would like to delete everything in a cell
from the period and anything following it.
Is there a way to do that?