Country Boy wrote:

> Hi
> 
> I am trying to get the new Google Maps system up and running on a web site
> and I have been told to prepare the data in the XML file with inverted
> commas as in the example below, which gives customer ID, Category name,
> address, town/city, county, post code and telephone number for the data to
> be uploaded into Google.

It's spreadsheet format called CSV (Comma-Separated Values).

> I have a large XML file prepared before I was given this advice and to
> individually do this to each entry will be excrutiatingly long and
> painful.
> Does anyone know of a formula where I can add " " as in the example below.
>  I have been told this is tab and comma delimited but I have not heard of
> that
> before and can't find it on my "save as".  I am using MS Excel 2003.

Look for CSV. It may be in the Export menu instead.

> "101","1","The Museum","Guildhall Square","Southampton","Hampshire","SO24
> 5BY","02380 512  6370"

Alternatively (and probably safer) write a short XSLT routine to output
each element with quotes around it, and a comma after all but the last.

///Peter