Remove Arrow

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

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
 
Elton said:
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
Click to expand...


=MID(A1,2,LEN(A1)-2)
 
Hi Elton Law
You could use >Find & Replace<.
Find > Replace with nothing, same for <
HTH
John
 
Back
Top