ConfusedMum
New Member
- Joined
- Apr 22, 2013
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hi all,
This should be really easy, I am sure, but I am totally stuck! I know about Text to Columns, but that doesn't seem to work if you have multiple text to split and I am not sure where to go next with this.
This is an example of what I have got at the moment:
What I am trying to get is this:
So I can split the postcodes into alphabetical order, with the sales person linked to that postcode, into individual rows; then I can add extra details like region, admin contact, supervisor, etc...
Any ideas wonderful Excel guru people please, please, please?
Thank you SO much,
Cathy
This should be really easy, I am sure, but I am totally stuck! I know about Text to Columns, but that doesn't seem to work if you have multiple text to split and I am not sure where to go next with this.
This is an example of what I have got at the moment:
What I am trying to get is this:
So I can split the postcodes into alphabetical order, with the sales person linked to that postcode, into individual rows; then I can add extra details like region, admin contact, supervisor, etc...
Any ideas wonderful Excel guru people please, please, please?
Thank you SO much,
Cathy