Re: Text format

From: Me (Me_at_discussions.microsoft.com)
Date: 08/03/04 

Date: Mon, 2 Aug 2004 23:45:01 -0700

Yes, I don't have upper case letters after the lower case letters, so AAA-ascv-DD is not an case. Even if will be I don't need that text. I only need the text fromthe start to "-" followed by an lower case letter. I fond how to return the 3+1 letter : =MID(A1;SEARCH("-";A1;1)+1;1) ---> B.

"Frank Kabel" wrote:

> Hi
> the question was if the lower case letters are ALWAYS
> AFTER the last '-'. That is the following string is not in
> your data list
> AAA-ascv-DD
>
> If this is not an allowed entry it would reduce the
> formula complexity
>
> >-----Original Message-----
> >Yes, the lower case letters are preceded by "-"
> >
> >Here is what I think:
> >1.SEARCH("-";A1;1) ---> result 3
> >2. Test character 4(3+1) from A1 with CODE() to get the
> ascii code
> >3. Lower case letters have the ascii code >=97, so if
> code <97 I will search the A1 text from character 4(or 5)
> to the end and see if there are any more "-" characters.
> >4. The second "-"have the search result 9 and I'll test
> character 10 who have the ascii code >=97. So I'll stop
> and copy A1 from 1-st to 8(9-1) characters to result "AA-
> BB CC"
> >
> > Can you tell me how to get for example the 3-rd
> character from A1 text ?
> >"Frank Kabel" wrote:
> >
> >> Hi
> >> is this text part always after the last '-'?
> >>
> >> --
> >> Regards
> >> Frank Kabel
> >> Frankfurt, Germany
> >>
> >>
> >> Me wrote:
> >> > Hy,
> >> >
> >> > I have an text how looks like this: "AA-BB CC-dd". I
> want to select
> >> > the text until the "-dd", so the result would be "AA-
> BB CC". So the
> >> > text until "-" followed by an lower case letter. How
> can I do that ?
> >>
> >>
> >.
> >
>

Relevant Pages

  • RE: Advanced Filter/Sort for Mixed Number and Letter Variables
    ... you run a query using ASCyou will get the ASCII code number for each, ... you can change the string of numerals into an actual value ... "Michael Conroy" wrote: ... numbers and letters were seperated at one time, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Text format
    ... the lower case letters are preceded by "-" ... Test character 4from A1 with CODEto get the ascii code ... "Frank Kabel" wrote: ...
    (microsoft.public.excel.misc)
  • Re: Text format
    ... the question was if the lower case letters are ALWAYS ... That is the following string is not in ... character 10 who have the ascii code>=97. ...
    (microsoft.public.excel.misc)
  • Re: Help a beginner - simple lowercase to uppercase and so on function
    ... can understand everything but it should take shape with more practice ... it compiles and returns uppercase letters ... in this string!" ... to compile on both. ...
    (comp.lang.c)
  • Re: adding a text string to data from one field in one database to another
    ... function that blocks anything but numbers or letters. ... Dim stAllowedChars as string ... dim stFrom as string stTo as string ... dim iPtr as integer. ...
    (comp.databases.ms-access)
Loading