Thread: Substitute
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrbalaje mrbalaje is offline
external usenet poster
 
Posts: 24
Default Substitute

Suppose if I have "1-2-3-4-5" or "12-1-34-56" in a cell. If there any formula
to retrieve only the number without the "-" in another cell.