View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PerryK PerryK is offline
external usenet poster
 
Posts: 19
Default how can I delete "*" formated as text

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks
--
Perry K