SimonHughes
Active Member
- Joined
- Sep 16, 2009
- Messages
- 452
- Office Version
- 365
- Platform
- Windows
Hello, I am a bit puzzled here as the text to columns is not working - there must be something in the formatting that is causing a problem. I am trying to get rid of the postcode after the city name and text to columns seemed the best way to do it. The column is formatted as "General" and I am using MS 365.
A formula would work as well so any suggestions on that score will be appreciated too.
A formula would work as well so any suggestions on that score will be appreciated too.
Peterhead AB42 |
Aviemore PH22 |
Edinburgh EH4 |
Glasgow G2 |
Prestwick KA9 |
Newcastle NE13 |
Newcastle NE3 |
Sunderland SR6 |