Pasting from Excel into IE text box

D

Douglas J. Steele

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

Your question might be better asked in a newsgroup related to Excel.
 
M

MBilliodeaux

I would like to select, from one row or record, three columns and paste
them into an IE text box. For example my three columns are Lastname,
Firstname, and MI. The record, then, would be Kennedy, John, F.

The problem: when I paste the record, Microsoft uses a tab to separate
each column of information. Therefore my results are as follows...
LNAME FNAME MI
Kennedy John F

I would prefer the results to be...
Kennedy John F

How do I change the default paste delimiter to a space instead of a
tab?

BTW I have already tried modifying the Format key...
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text
to "Delimited( )"

- Cheers, MBilliodeaux
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top