Copy/paste between Access and Excel

Question

in one of my form in Access, i want to put together some texts in a string, then my user can copy this string into Excel, in different columns. For example, there are 5 letters in my form: A B C D E, when the users hit a button "copy", then do the paste in Excel, say in the case A1. Then the 5 letters will be pasted into 5 columns in one row:

A1 B1 C1 D1 E1

A B C D E

What i am searching is whether there is a symbol just to indicate the end of a column.

Answer 1

You can use tabs between each value, and Excel will break the data up into columns when it's pasted in.