Thread: Remove the char from right
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ranjith Kurian[_2_] Ranjith Kurian[_2_] is offline
external usenet poster
  
Posts: 48
Default Remove the char from right
i need a excel function to remove the character from right, and its been
identified by the symbol "-", example as shown below

QUESTION:
Code
123-ibb
US456-europ
UKASDGG-1234HR

ANSWERS:
Code
123
US456
UKASDGG


Reply With QuoteReply With Quote