Merging Cells

[Dave Peterson]

Yep. Starting points for instructions can be difficult to pinpoint. I used to
joke to my co-workers that I really don't want to tell them how to set their
alarm clocks and get ready for work--much less document their path to work--or
how to find the on/off switch on the pc.

But I read Gord's instructions and they seemed quite reasonable to me <bg>.

If I were you, I'd revisit his instructions and try it once more. If you have
questions, post back with the steps you followed (which could be difficult to
document <vbg>).

You may find that Gord's function useful later--or you may find that you need
something different that can't be done in MSWord.

Just a thought (or two).

 

[David McRitchie]

Hi David,
To me it looks
like you are trying to create a .csv (Comma Separated Values)
file, which Excel is perfectly able to create with a File, Save As
and for more troublesome stuff you can use a macro

Comma Separated Values, .CSV files
http://www.mvps.org/dmcritchie/excel/csv.htm

Are you Sure you need everything in one cell. After you get
everything in one cell, what do you do with it. If it is simply
paste it into notepad then you could have created the flat
file directly out of Excel.
Create CSV files from each sheet in selection, Dave Peterson, 2005-09-15, public.excel
http://groups.google.com/[email protected]
=--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[David]

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

--
David Kitching Msc. Msc.
Managing Director
Natural Deco Ltd.
The Manor
Manor Lane
Loxley
Warwickshire CV35 9JX
UK.

Tel: +44 (0) 1789 470040
Mob: +44 (0) 7799 118518
www.naturaldeco.co.uk

 

[SteveW]

I ended up:

creating a second column where each cell contained just a comma and a
space.

creating a thrid column where the other two were combined.

Copying the whole third column and pasting it into Word.

Merging the relevant cells in Word

and then special pasting each merged cell contents as unformatted text..

Then each bit was cut and pasted back into each of the 9 cells.

Took all day but it's done!

if you were going to use word you could have just replace *newline* with
", "

 

[SteveW]

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

Steve