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" <
[email protected]> wrote
in message news:
[email protected]...
>
> 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...o&userid=11019
> View this thread: http://www.excelforum.com/showthread...hreadid=396875
>
Bookmarks