Thread: Merging Cells
View Single Post
  #25  
Old September 2nd, 2006, 08:36 PM posted to microsoft.public.excel.newusers
SteveW
external usenet poster
 
Posts: 399
Default Merging Cells

So your database will only have 9 entries - fair enough
Just all seems odd manipulation of data for end result.

Steve


On Sat, 02 Sep 2006 19:36:53 +0100, David wrote:

But saving as a .csv file, which I tried, just seemed to produce a file
which, when opened, looked exactly the same as the .xls, with everything
in
cells. OK, I now know that if I rename the csv to a txt, I can open it in
wordpad and get my data in a column without cells, copy it all and paste
special it as unformatted text. But that's what I did anyway, using word.

I need the data in nine cells because it's used to generate a table in a
sql
database where a website will check a custoemrs postcode and, depending
on
which column the postcode occurs in, it can apply a shipping charge
appropriate for listed quantity ordered.

Cheers
David