Re: Erase numeric digits only
From: an (anonymous_at_discussions.microsoft.com)
Date: 05/26/04
- Next message: JE McGimpsey: "Re: Erase numeric digits only"
- Previous message: raehippychick: "Re: how do I summarize worksheets into the first sheet for a mail merge please?"
- In reply to: Frank Kabel: "Re: Erase numeric digits only"
- Next in thread: JE McGimpsey: "Re: Erase numeric digits only"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 May 2004 09:30:38 -0700
Ok, FK.
Work OK!
Many thanks.
an
>-----Original Message-----
>Hi
>if the numbers always start at the beginning try the
following array
>formula (entered with CTRL+SHIFT+ENTER):
>=MID(A1,MAX(IF(ISNUMBER(--MID(A1,ROW(INDIRECT
("1:1024")),1)),ROW(INDIRE
>CT("1:1024"))))+1,1024)
>
>--
>Regards
>Frank Kabel
>Frankfurt, Germany
>
>
>an wrote:
>> Hello!
>>
>> I have an alphanumeric column data with:
>>
>> nnnTEXT
>> nnnnnTEXT
>> nTEXT
>> nnTEXT
>> ...
>>
>> Where n=numeric digits
>>
>> In column, I need to erase all numeric digits, to TEXT.
>> Is it possible with Excel Function?
>>
>> Thanks in advance.
>> an
>
>.
>
- Next message: JE McGimpsey: "Re: Erase numeric digits only"
- Previous message: raehippychick: "Re: how do I summarize worksheets into the first sheet for a mail merge please?"
- In reply to: Frank Kabel: "Re: Erase numeric digits only"
- Next in thread: JE McGimpsey: "Re: Erase numeric digits only"
- Messages sorted by: [ date ] [ thread ]
