www....com does not stay active in excel 2010

		Microsoft Office Forums > Microsoft Excel > Excel
www....com does not stay active in excel 2010

FAQ

Thread Tools

Display Modes

06-08-2012, 11:05 PM

macropod

Windows 7 64bit www....com does not stay active in excel 2010

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,526

• In a spare column, input: =HYPERLINK(A1)
• Copy down as far as needed
• Select the data in the 'spare' column
• Copy the data
• Use Edit | Paste Special > Values
• Copy the data
• Paste over the original data
• Delete the 'spare' column.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2010 and Excel 2010 Mail merge - multiple headers	robby	Word	3	04-18-2012 06:37 PM
Stay on One Page - 100%	mnp	Word	1	12-30-2011 11:57 AM
can't get text to stay aligned for printing	cherd	Word	1	10-06-2011 03:20 AM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM
Auto Correct to Stay On	sanzlink	Word	1	01-16-2009 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 AM.