Trying to paste a link and merge formatting

macropod · #2 04-15-2013, 11:28 PM

Try making your copy/paste start with the period (i.e omit http://www). If the paste starts with the period, you won't get the unwanted space. Similarly, if the copied string terminates in a '/', a trailing space isn't inserted.

An alternative would be to use a macro:

Code:

Private Sub PasteUnformattedText()
Dim MyData As DataObject
On Error GoTo ErrExit
Set MyData = New DataObject
MyData.GetFromClipboard
Selection.Range.Text = MyData.GetText
ErrExit:
End Sub

The above macro has broader application than your html coding, being useful for any unformatted text pasting. Simply assign it to a keyboard shortcut.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste Special: Copy and Paste Formatting Only?	tinfanide	Word	6	03-06-2013 12:21 AM
Paste formatting	LarryStroup	PowerPoint	1	12-11-2012 12:10 AM
Link and Keep Source Formatting--not exact	minny	Excel	2	04-09-2012 04:19 PM
Paste Special Link no longer working	MrsMoe	PowerPoint	0	12-20-2010 10:54 PM
Paste Excel Link As	tphillippe	PowerPoint	1	11-26-2009 05:54 PM