Prev: Formula for counting frequency then sorting
Next: IF equation will not calculate
From: Elton Law on 7 Apr 2010 10:16
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
From: Glenn on 7 Apr 2010 10:29
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)
From: John on 7 Apr 2010 11:37
Hi Elton Law
You could use >Find & Replace<.
Find > Replace with nothing, same for <
HTH
John
"Elton Law" <EltonLaw(a)discussions.microsoft.com> wrote in message
news:EE3A343F-BB89-4C7A-8B3A-5ADE2BE4D7B3(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Formula for counting frequency then sorting
Next: IF equation will not calculate