Thread: Remove Arrow
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Remove Arrow
Elton Law wrote:
Dear Expert,
Got system generated files ...
<.HSI
<0941.HK
<2828.HK

Is there any functions that can let me capture the content only?
That is no "<" and "" ...
Thanks
Elton


=MID(A1,2,LEN(A1)-2)
Reply With QuoteReply With Quote