help please ....tidy up some data

[mrowe]

Hi, I've got a large list of data that imports like the example below. I've been asked to split the record into more than one collumn (i.e Addr1, Addr2,County,Country,PostCode)

I've tried substitue and replace to get rid of the � but it's not working. Anyone got an idea of how to tidy this up?


"Acresfield�St Ann's Square� 8-10 Exchange Street� Manchester�"

Thanks in advance
Matt

 

[PaddyD]

duplicate:
http://216.92.17.166/board/viewtopic.php?topic=27054&forum=2&4