ExcelBanter - Remove Arrow

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Remove Arrow (https://www.excelbanter.com/excel-worksheet-functions/260908-remove-arrow.html)

Elton Law[_2_]

Remove Arrow

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

Glenn

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)

John[_22_]

Remove Arrow

Hi Elton Law
You could use Find & Replace<.
Find Replace with nothing, same for <
HTH
John
"Elton Law" wrote in message
...
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

All times are GMT +1. The time now is 11:55 PM.