Seperate Text and numbers in Post code
Chriso --
What does Birmingham's code look like?
"chriso" wrote:
Hi
I have a data sheet and need to get just the area from a post code e.g BS1
1JN I need just the BS in a column. I would use left,2 etc but problem is
some codes such as Birmingham only have 1 letter.
Any ideas please.
Thanks
Chris
|