Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21   Report Post  
Old September 2nd 06, 01:46 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Merging Cells

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 wrote:

I tried it that way, I honestly did. Then reverted to including content that
should, clearly, have been replaced. I entered the phrase 'A2:A150' and also
A2,A150' just to be sure. But, whilst the help and advice of experts such as
yourselves is greatly appreciated, do understand that it's sometimes easy to
forget just what degree of detail is needed in describing how to do
someting. I've been an IT trainer and do have some experience of this.
Imagine telling someone how to drive a car, who's never seen one
before...how would you describe changing gear? In terms of a gearstick? Of
second and fourth etc? What's a gear??

Anyway, I got there in the end. And to my mind, it's a shame that Excel has
so much trouble doing something so simple. Concatenating data in cells. Word
can do it!

Thanks for all your interest.

--
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

"Pete_UK" wrote in message
ups.com...
Too late, Gord, he's already done it using Word. Anyway, Dave told him
that yesterday.

Pete

Gord Dibben wrote:
David

There is no exclamation mark in my code.

I think that when you copied the code you also copied the Usage
instructions.

Just copy the part from

Function ConCatRange(CellBlock As Range) As String

down to and including

End Function


Gord

On Fri, 1 Sep 2006 09:33:51 +0100, "David" wrote:

Many thanks for this. But I keep getting the message'Compile Error:
Expected: list seperator or )' and the exclamation mark in the code
becomes
highlighted.

David

Gord Dibben MS Excel MVP



--

Dave Peterson

  #22   Report Post  
Old September 2nd 06, 02:18 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 903
Default Merging Cells

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/groups?thre...zonXSPAM.ne t
=--
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" wrote in message ...
Hi

I have a list of a couple of thousand postcodes in a column in a
spreadsheet. Each postcode occupies its own cell. Examples of each postcode
might be AB10 or AB11 or AB12 etc. I want to cut and paste these postcodes
to another sheet, many codes to be pasted into single cells.

I tried to merge the cells as they stand so that I could collectively copy
and paste them but excel says that the cells contain multiple data values
and won;t let me merge them.

Can anyone tell me how to do this without cutting and pasting the contents
of each cell, one at a time please?

Many thanks
Dave




  #23   Report Post  
Old September 2nd 06, 07:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 17
Default Merging Cells

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

"David McRitchie" wrote in message
...
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/groups?thre...zonXSPAM.ne t
=--
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" wrote in message
...
Hi

I have a list of a couple of thousand postcodes in a column in a
spreadsheet. Each postcode occupies its own cell. Examples of each
postcode
might be AB10 or AB11 or AB12 etc. I want to cut and paste these
postcodes
to another sheet, many codes to be pasted into single cells.

I tried to merge the cells as they stand so that I could collectively
copy
and paste them but excel says that the cells contain multiple data values
and won;t let me merge them.

Can anyone tell me how to do this without cutting and pasting the
contents
of each cell, one at a time please?

Many thanks
Dave






  #24   Report Post  
Old September 2nd 06, 08:28 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 427
Default Merging Cells

On Fri, 01 Sep 2006 21:06:06 +0100, David wrote:

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
", "

--
Steve (3)
  #25   Report Post  
Old September 2nd 06, 08:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 427
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



Reply
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
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
Merging and unmerging cells [email protected] Excel Worksheet Functions 1 April 11th 06 04:19 PM
Merging cells with the same values Iain Excel Discussion (Misc queries) 0 August 8th 05 06:35 PM
Merging Two Cells and Keeping the Values Raymond Excel Discussion (Misc queries) 10 May 30th 05 08:05 PM
Merging cells with text as one line Jim Excel Worksheet Functions 1 December 23rd 04 01:29 AM


All times are GMT +1. The time now is 12:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017