Postcode sorting with in the uk

%3CLINGO-SUB%20id%3D%22lingo-sub-2575094%22%20slang%3D%22en-US%22%3EPostcode%20sorting%20with%20in%20the%20uk%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2575094%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20have%20place%20all%20the%20postcodes%20in%20to%20column%20A%20is%20there%20a%20function%20that%20will%20separate%20them%20in%20to%20individual%20area%20so%20ba%20and%20bs%20would%20go%20in%20to%20individual%20columns%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2575094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2575316%22%20slang%3D%22en-US%22%3ERe%3A%20Postcode%20sorting%20with%20in%20the%20uk%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2575316%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1110063%22%20target%3D%22_blank%22%3E%40Chrisw82%3C%2FA%3E%26nbsp%3BI%20don't%20know%20what%20%22ba%20and%20bs%22%20means%2C%20but%20on%20the%20Data%20ribbon%20you%20can%20use%20Text-to-Columns%2C%20provided%20that%20the%26nbsp%3B%22ba%20and%20bs%22%20are%20always%20in%20the%20same%20position%20within%20the%20text%20string.%3C%2FP%3E%3CP%3EIf%20this%20makes%20no%20sense%2C%20why%20not%20upload%20your%20list%20so%20that%20it%20becomes%20clear%20as%20to%20what%20you%20are%20dealing%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi I have place all the postcodes in to column A is there a function that will separate them in to individual area so ba and bs would go in to individual columns   

1 Reply

@Chrisw82 I don't know what "ba and bs" means, but on the Data ribbon you can use Text-to-Columns, provided that the "ba and bs" are always in the same position within the text string.

If this makes no sense, why not upload your list so that it becomes clear as to what you are dealing with.