Re: Left() or Right()

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
>

.

Relevant Pages

  • Re: OR Expression on a Form
    ... I tried your language and the OR ... is on a subform from a different query? ... I am only displaying this on the ... >> Best regards, ...
    (microsoft.public.access.forms)
  • Re: E-mailing report
    ... it's in the formscoding newsgroup. ... Bill ... > Following on from my previous post in regards to displaying the last ...
    (microsoft.public.access.reports)
  • Re: _ecvt, _gcvt and _fcvt problem
    ... >> for displaying I'm using 2 way; ... >> 2.this function in a dll, ... > The result was 0.1 as a character array. ...
    (microsoft.public.vc.language)
  • E-mailing report
    ... Following on from my previous post in regards to displaying the last record ... in a report. ... Now I need to automatically e-mail that single page to an e-mail ...
    (microsoft.public.access.reports)
  • Re: images using graphics class
    ... web user control. ... a file and simply displaying the file. ... >> I'm trying to create a bitmap and then use outputstream to display the ...
    (microsoft.public.dotnet.general)