Re: Merging Columns in Excel
Re: Merging Columns in Excel
- Subject: Re: Merging Columns in Excel
- From: Paul Berkowitz <email@hidden>
- Date: Tue, 12 Feb 2002 09:23:59 -0800
On 2/12/02 1:12 AM, "David Hood" <email@hidden> wrote:
>
Paul Berkowitz <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.
>
>
The only way I know of (using Excel 98) is pretty ugly. You need to know the
>
number of fields/columns in the file. Assuming I have two fields I want to
>
concatenate (Column1 and 2) I place the resulting concatenation in column 3:
Thanks, David. I think I'll go on doing what I've been doing for extracting
the info to a text file. But this is very useful for future use. I see I'll
have to read up on Formulas. Am I likely to find what I need in the regular
Excel Help, or would this be in the VB Editor Help? Or just in a book
somewhere?
--
Paul Berkowitz
_______________________________________________
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.