Re: Left() or Right()


RD,

I really have no idea why this is happening. I have asked around to
check if they are experiencing the same thing as you are and,
unfortunately, no one has. I guess this is one of the things that we
have to put up with in this high tech world that we live in right now.



RagDyer Wrote:
> FWIW,
>
> Your suggested formula is being distorted when displaying in my O.E.
> reader.
>
> I see your formula in upper case, like it was copied directly from the
> XL
> formula bar, and the <space> is depicted as
> \" \"
> backslash,dbl quote,space,backslash,dbl quote.
>
> I had to go into excelforum to see your actual formula,
> which was in lower case, as you might have typed it directly into the
> post,
> and the space was properly displayed between 2 dbl quotes.
>
> Does anyone know why ???
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit
> !
> ---------------------------------------------------------------------------
>
> "BenjieLop" <BenjieLop.1tyz6g_1124384712.9533@xxxxxxxxxxxxxxxxxxxxx>
> wrote
> in message
> news:BenjieLop.1tyz6g_1124384712.9533@xxxxxxxxxxxxxxxxxxxxxxxx
> >
> > giantwolf Wrote:
> > > Hi,
> > >
> > > I have a list of postcodes (zip codes) that I need to 'extract'
> part of
> > > and allocate to a new cell.
> > >
> > > eg:
> > >
> > > AL1 2TQ
> > > AL1 5RD
> > > AL22 9IP
> > >
> > > I need to take the first characters before the space however it
> could
> > > be 3 or 4 characters before each space. I need a formula that
> will
> > > start from the left and take anything before a space or one that
> starts
> > > from the right and takes anything before the righthand 3 characters
> and
> > > the space. I've tried left and right but can't quite get it to
> work.
> > >
> > > Any ideas? Thanks in advance.
> >
> > Try this ...
> >
> > =LEFT(A1,FIND(\" \",A1)-1)
> >
> > and copy down as required.
> >
> > Regards.
> >
> >
> > --
> > BenjieLop
> >
> >
> >
> ------------------------------------------------------------------------
> > BenjieLop's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=11019
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=396875
> >


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=396875

.

Relevant Pages

  • Re: Position of a cell in a range
    ... Thank you for pointing it out. ... Regards. ... BenjieLop ... BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: how do i make a value entered be * 2
    ... Regards. ... BenjieLop ... BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019 ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Help with Formulas
    ... is your formula and next time, it is not necessary to multipost ... Regards. ... BenjieLop ... BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019 ...
    (microsoft.public.excel.misc)
  • Re: Excel Graph
    ... Regards. ... BenjieLop ... BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
    ... Regards. ... BenjieLop ... BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)