Yusuf
Active Member
- Joined
- Jun 1, 2004
- Messages
- 337
Hi
I have a column with cells containing City names and Post codes together and need to split them to return only the City name.
Should the City name be there alone, then it should be returned as is.
Eg.
A1 - London S7 2GY
A2 - Crawley CS4 9JK
A3 - Edinburgh EH26 8NF
The length of the postcode could change depending on the area.
Any help with this would be greatly appreciated.
I have a column with cells containing City names and Post codes together and need to split them to return only the City name.
Should the City name be there alone, then it should be returned as is.
Eg.
A1 - London S7 2GY
A2 - Crawley CS4 9JK
A3 - Edinburgh EH26 8NF
The length of the postcode could change depending on the area.
Any help with this would be greatly appreciated.