View Single Post
  View Parent  #17  
Old May 27th, 2015, 01:46 PM
Efrem Mallach
Guest
 
Posts: n/a
Default Re: [Dixonary] Question

Then you ought to be able to paste the table as is into Quattro Pro and concatenate things there. The formula in Excel would work like this. Quattro Pro does the same thing in a similar (perhaps identical) way:

If you have "Barrs" in cell A2 and "John" in cell B2, then this formula in cell C2:

=A2 & ", " & B2

would produce "Barrs, John" in C2.

However, I don't think you have to leave WordPerfect for this. It supports all sorts of formulas directly in its tables. I'm not sure if it has & as a concatenate operator, but I know it has the CONCAT function that does much the same thing. You ought to be able to use

=CONCAT(A2, ", ", B2)

in cell C2 to get the same result.

Efrem

=-=-=-=-=-=-=-=-=-=-=-=
On May 27, 2015, at 2:36 PM, Judy Madnick <jmadnick (AT) gmail (DOT) com> wrote:

> Efrem,
>
> I'm not using a spreadsheet (in my case it would be Quattro Pro, not Excel). I'm using a WordPerfect table. To be honest, I don't even understand the spreadsheet terminology!
>
> Judy
>
> Original message
> From: "Efrem Mallach" <emallach (AT) verizon (DOT) net>
> To: dixonary (AT) googlegroups (DOT) com;
> Dated: 5/27/2015 2:33:55 PM
> Subject: Re: [Dixonary] Question
>
> Judy,
>
> When I want to e-mail stuff from an Excel table, I use its Concatenate operator (&) in a formula that connects strings in different columns into a single string in one column of the same row, adding whatever punctuation seems appropriate between items. Then I can paste that column with no formatting issues.
>
> Efrem
>
> =-=-=-=-=-=-=-=-=-=-=-=
> On May 27, 2015, at 2:22 PM, Tim Lodge <5sfwiyj02 (AT) sneakemail (DOT) com> wrote:
>
>> Judy
>>
>> When I deal, I copy and paste an MS Excel table directly into the compose screen on the Google Groups website for the results, and it retains the table formatting. However, I don't know whether it works if you're posting the results by email.
>>
>> -- Tim L
>>
>> On Wednesday, May 27, 2015 at 7:04:32 PM UTC+1, Judy Madnick wrote:
>> Yes, but I'm not sure that it makes much difference from what I'm reading in the "reveal codes." The codes for the table are still there. Once this round is finished (this evening) I'll see what happens when I use the WordPerfect table.
>>
>> Judy
>>
>> Original message
>> From: "Paul Keating" <kea... (AT) acm (DOT) org>
>> To: dixo... (AT) googlegroups (DOT) com;
>> Dated: 5/27/2015 1:58:46 PM
>> Subject: RE: [Dixonary] Question
>>
>> Does WP have a table-to-text function, by any chance?
>>
>> On 27 May 2015 19:53, "Judy Madnick" <jmad... (AT) gmail (DOT) com> wrote:
>> I understand that, Steve. See my reply regarding copying and pasting the WordPerfect document.
>>
>> Judy
>>
>> Original message
>> From: "Steve Graham" <sdsg... (AT) gmail (DOT) com>
>> To: dixo... (AT) googlegroups (DOT) com;
>> Dated: 5/27/2015 1:42:09 PM
>> Subject: RE: [Dixonary] Question
>>
>> Which is to say:
>>
>>
>> 1. Select the appropriate text.
>>
>> 2. Copy the selected text (Ctrl-C in Windows)
>>
>> 3. Paste the copied text into the message (Ctrl-Insert in Windows)
>>
>>
>> Steve Graham
>>
>>
>> From: dixo... (AT) googlegroups (DOT) com [mailto:dixo... (AT) googlegroups (DOT) com] On Behalf Of Paul Keating
>> Sent: Wednesday, May 27, 2015 10:40
>> To: dixo... (AT) googlegroups (DOT) com
>> Subject: Re: [Dixonary] Question
>>
>>
>> Have you tried pasting from the .pdf?
>>
>> On 27 May 2015 19:08, "Judy Madnick" <jmad... (AT) gmail (DOT) com> wrote:
>>
>> Johnny,
>>
>>
>> I create the list (actually, a table) in WordPerfect and can then convert to .pdf. It appears that I can't paste the .pdf in a message, but I can convert the .pdf to a .jpg and paste that. I could try that, and if it doesn't work...retype everything into a message. Copying and pasting the text from the WordPerfect file doesn't work well.
>>
>>
>> Judy
>>
>>
>> Original message
>> From: JohnB <jo... (AT) john-barrs (DOT) co.uk>
>> To: dixo... (AT) googlegroups (DOT) com;
>> Dated: 5/27/2015 9:30:30 AM
>> Subject: Re: [Dixonary] Question
>>
>> Judy
>>
>> if you have to create the list in pdf you can create it anywhere. If you use Acrobat just copy and paste into a message - I personally would be negative to a file because of the extra work and expense it would cost me to un-pdf it
>>
>>
>> JohnnyB
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+u...@ googlegroups.com.
>> For more options, visit https://groups.google.com/d/ optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+u...@ googlegroups.com.
>> For more options, visit https://groups.google.com/d/ optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+u...@ googlegroups.com.
>> For more options, visit https://groups.google.com/d/ optout.
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+u...@ googlegroups.com.
>> For more options, visit https://groups.google.com/d/ optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+u...@ googlegroups.com.
>> For more options, visit https://groups.google.com/d/ optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+u...@ googlegroups.com.
>> For more options, visit https://groups.google.com/d/ optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Dixonary" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email todixonary+unsubscribe (AT) googlegroups (DOT) com.
>> For more options, visit https://groups.google.com/d/optout.

>
>
> --
> You received this message because you are subscribed to the Google Groups "Dixonary" group.
> To unsubscribe from this group and stop receiving emails from it, send an email todixonary+unsubscribe (AT) googlegroups (DOT) com.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to the Google Groups "Dixonary" group.
> To unsubscribe from this group and stop receiving emails from it, send an email todixonary+unsubscribe (AT) googlegroups (DOT) com.
> For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups "Dixonary" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dixonary+unsubscribe (AT) googlegroups (DOT) com.
For more options, visit https://groups.google.com/d/optout.
Reply With Quote