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