Hi,
I have a spreadsheet that is populated with Name and
Address data from a SQL Server database using MS Query.
Unfortunately the database stores the address in one
column, with the different parts (ie street, town/suburb)
seperated with Carriage Returns. Is there any way I can
replace this with a characted such as % or | (I know how I
can seperate it into different columns if I can replace it
with a unique character)

Thanks