| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Macro (VB) code for arrow down & arrow up | Excel Discussion (Misc queries) | |||
| Using end-arrow down or end-arrow up in a macro | Excel Discussion (Misc queries) | |||
| why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
| remove comment arrow | Excel Discussion (Misc queries) | |||
| How to do the following by pressing the down arrow or up arrow key? | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
