Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paste HTML format but not html code (tags, etc)

Status
Not open for further replies.
dpav29

dpav29

Technical User
Aug 3, 2001
155
US
I am pasting table info from the web into excel. If I do a straight paste, the column formatting comes over clean. If I do paste/special/text, the formatting is messed up. The problem is that each time I paste, excel stops responding for up to 2 minutes before completing the paste. I'm assuming it has something to do with the complexity of the html data??? When I save the file, I save it as TAB delimited text and continue the pasting (I have hundreds of pages to paste), but that doesn't help. . .it still bogs down with every paste.

Any ideas?
 
Status
Not open for further replies.

Similar threads

shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
2K
shytott
shytott
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
605
combo
combo
bhujanga
  • Locked
  • Question
Prevent Converstion of Long Numeric Strings to Exponential Format 1
Replies
4
Views
432
remeng
remeng
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
1K
SkipVought
S
Wicca
  • Locked
  • Question
MAXIFS - transfers NUMBERS but wont transfer <1.6 from one tab to another
Replies
16
Views
694
Wicca
Wicca

Part and Inventory Search

Sponsor

Back
Top