Re: Left() or Right()
- From: BenjieLop <BenjieLop.1tyz6g_1124384712.9533@xxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 18 Aug 2005 11:24:22 -0500
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
.
- Follow-Ups:
- Re: Left() or Right()
- From: RagDyer
- Re: Left() or Right()
- References:
- Left() or Right()
- From: giantwolf
- Left() or Right()
- Prev by Date: Right ..... whaere to start
- Next by Date: RE: Help with a formula
- Previous by thread: RE: Left() or Right()
- Next by thread: Re: Left() or Right()
- Index(es):
Relevant Pages
|
