Postal code to Area translation

[idxearo]

I have some postal codes all in one column.
eg EN1 7IH, and N1 M3

I want to create a column where excel reads the first characters BEFOR
the space, since those characters represent an Area.

I want to be able to add the name of the postal code area in the ne
column. For example EN1 = Area1 and N1 = Area

 

[idxearo]

You will need to have a table set up in your work sheet with the pos
codes listed and a area allocated to each code, As in the UK there ar
over a hundred. Then you could use a LOOKUP or INDEX & MATCH etc.
EG: =VLOOKUP(LEFT(Cell/Ref,2),Your_Range,Column,0)

Thank you very much I will try and let you know how this goes

 

[Spencer101]

EG = "EXAMPLE" !!

Yes, Kevin, I know what it means.

But your EG was not going to do what the OP needed, so I stepped in wit
a better EG