I have received an extract of data that should represent an address in a single column of data. This should be split into address1, 2, 3, 4 - but for some reason the only export facility puts all the address segments into a single cell, e.g
123 ee street city state
there is no consistency between the number of blank spaces per address 'segment'. Can anyone think of a way of splitting the segments into separate cells? I cant even use spaces in text to columns as each segment can contain spaces, e.g. "123 ee street" is one segment but using spaces would split "123", "ee", "street".
bit of a nightmare task so any ideas most welcome. Its currently an excel spreadsheet but I suppose I could convert to something else if that will make the segregation better/easier.