Copy and paste in Excel does not work

[feno...@gmail.com]

Dear all,

I don´t seem to get the results from the concordance search into Excel. After generating the results, I select the columns (e.g., using the Shortcut ALT A), copy the contents (using CTRL C), and then paste them into Excel (CTRL V), bu all I get is one big mess...

Does anyone know the aswer to this problem?

Thanks!

Fenna

[Laurence Anthony]

What do you mean by "one big mess"? Have you tried delimiting the search word with tabs via the Concordance settings menu?

Laurence.

--
You received this message because you are subscribed to the Google Groups "AntConc-discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to antconc+u...@googlegroups.com.
To post to this group, send email to ant...@googlegroups.com.
Visit this group at http://groups.google.com/group/antconc.
For more options, visit https://groups.google.com/d/optout.

[Fenna]

Dear Anthony,

Thank for your reply.
You made a Great tool!
With mess I mean that their are no  columns nice and neatly.
What do You mean with delimiting the search word with tabs via the Concordance settings menu?

Thx
Fenna

---

Van: Laurence Anthony
Verzonden: ‎30-‎9-‎2015 15:00
Aan: ant...@googlegroups.com
Onderwerp: Re: [antconc:1372] Copy and paste in Excel does not work

You received this message because you are subscribed to a topic in the Google Groups "AntConc-discussion" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/antconc/TrwUu6HGcxg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to antconc+u...@googlegroups.com.

[Fenna Swart]

dear Anthony,

I am also sending you a screenshot of what it looks like when I copy the results into Excel.

See attachment. What goes wrong..?

Best

fenna

--
You received this message because you are subscribed to a topic in the Google Groups "AntConc-discussion" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/antconc/TrwUu6HGcxg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to antconc+u...@googlegroups.com.

[Laurence Anthony]

Hi,

First you need to expand the columns to see exactly what is in each. If the results are not what you want, go to the Concordance settings menu in AntConc and you will see the delimiter option. It puts tabs around the search word in the results allowing it to be copied into its own column in Excel. Try it! You'll understand once you see the effect.

Laurence.

[Fenna]

Hi Laurence,

Thx! I actually did all that but it still does not come out properly. What else could cause this? Do You know?

Best
Fenna

---

Van: Laurence Anthony
Verzonden: ‎30-‎9-‎2015 17:39
Aan: ant...@googlegroups.com
Onderwerp: Re: [antconc:1375] Copy and paste in Excel does not work

[Laurence Anthony]

Hi again,

First, simplify the problem. Write a test.txt file with the following content: "the cat sat on the mat".

Then create a concordance output for "the" (2 rows in the KWIC output).

Make sure you can copy and paste the results into Excel keeping the "the" column separate. Once you do this, you will probably be able to find out the problem on your bigger corpus.

Laurence.