Remove Arrow

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
 
G

Glenn

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)
 
J

John

Hi Elton Law
You could use >Find & Replace<.
Find > Replace with nothing, same for <
HTH
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove unnecessary rows 2
Allow Delete cells but not rows 1
Arrange to present in continuous format 4
Return value from cell info 2
12 dependent series 5
Look for Max and second Max 0
Match the Excel File content with word document 4
Insert comment into cell 4

Top