You are reading a single comment by @christianSpaceman and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@christianSpaceman
You can write a vba function to wrap the vba 'split'function up and make it accessible from the spreadsheet. You could then split your strings on the commas to chop it up a bit.
That would get you half way there, but requires knowledge of vba and array formulas :)
You could approach it the other way. Write a long list of all the postcodes out ( B1,B2...B98) then try to work out a way to see if they're in your list above. Mark any not there for deletion.
But yeah... Get someone to rewrite it. That's stupid input :)