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

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

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