copy and paste from Excel to memo field

[le888]

Hi,

How can I migrate this problem? I copy several cells from a Excel file then I paste to a memo field in a form. However, squares appear in the memo field. Is it possible to disappear these square automatically? Also, is it possible to use these square as alignment in the memo field. For example that is what look like in the memo field:

3311
2.005.0010.0025.0050.0075.00100.00150.00200.00300.00
707580859095100105110115
4654.004622.004550.004406.004262.004278.004415.004626.00
311211000
24111015116342
80373451381912147
1356258876534212514

I would like the memo field look like in the out.txt file. Please see out.txt file.


Thanks,

Le888

 

[le888]

Here is the out.txt file...

Le888

 

[boblarson]

Looks like there are embedded tab or space characters.

 

[le888]

Looks like there are embedded tab or space characters.

Yes, the squares represent the tabs in MS Words format. So is it possible to arrange these tab automatically in a memo field. Please attachement. What I have done in the memo field is I delete the tab and replace by a space. Is it possible to do this automatically?

Thanks,

Le888