Technical Discussion
  >> Windows Issues


Register (or login) on our website and you will not see this ad.


These posts have been archived and can no longer be replied to or modified.
  Print Thread
Standard User deleted
(deleted) Sat 14-Jul-07 18:54:20
Print Post

Trimming a postcode in Excel / Access


[link to this post]
 
I have some postcodes which I would like to just get the first part of the postcode so for example

BD20 8BD would get returned as BD20
LS2 4JK would get returned as LS2

So basically I want the first part before the space. What function can do this in Excel? as I cannot seem to find one that works Or if this can be done in Access?

Thanks!
Standard User planetbrain
(learned) Sat 14-Jul-07 19:37:21
Print Post

Re: Trimming a postcode in Excel / Access


[re: deleted] [link to this post]
 
=LEFT(A1,SEARCH(" ",A1)-1)

Assuming the postcode is in cell A1, and the postcode is entered with a space in the middle.




you may be right, but I'm not wrong

madasafish
Standard User deleted
(deleted) Sun 15-Jul-07 01:45:54
Print Post

Re: Trimming a postcode in Excel / Access


[re: planetbrain] [link to this post]
 
Great Stuff

Many Thanks


Register (or login) on our website and you will not see this ad.

  Print Thread

Jump to