LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Country Boy
 
Posts: n/a
Default adding formula to existing database

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 Excel 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
converted to XML and then uploaded into Google.

I have a large Excel 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.

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

--
Ta!

Country Boy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding extra text into an existing column Zach Excel Worksheet Functions 2 August 11th 05 05:26 PM
Formula help : adding Niki New Users to Excel 3 March 24th 05 06:43 AM
Adding an extra validation to this formula. Mindie Excel Discussion (Misc queries) 1 March 7th 05 11:49 PM
Adding a formula to a pivot table Tony Excel Discussion (Misc queries) 2 January 20th 05 10:27 AM
DATABASE FORMULA becky Excel Discussion (Misc queries) 1 January 20th 05 01:45 AM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"