Re: Merging Columns in Excel
Re: Merging Columns in Excel
- Subject: Re: Merging Columns in Excel
- From: David Wignall <email@hidden>
- Date: Sun, 17 Feb 2002 22:59:24 +1300
Oops, this has been sitting in my Drafts for nearly a week waiting for me to
do something. Sorry.
on 12/2/02 6:59 pm, Paul Berkowitz at email@hidden wrote:
>
Is there a way to merge columns in Excel AppleScript? I'm told that there is
>
a way to do this in the UI, so I'm curious. Since my data is ultimately
>
destined for a tab-delimited text file, I'm just doing it row by row (Value
>
of Row, combine items of list with " " between them). It might be neater to
>
let Excel do it, although I gather it creates a carriage return that way. (I
>
won't be Saving As... Text because I don't want all the quotation marks
>
around cell values with punctuation, but will be substituting special
>
characters for returns, etc.)
The only time I see quote marks when I "Save as xlText" is when the cell
value already possesses quote marks, in which case it "triples" them; from
memory that is a VBA way of escaping double quotes. You do get returns at
the end of all but the last row. No other punctuation causes any similar
issue.
Have you got an example we can play with?
--
Dave
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.