How to change links to regular text

's Computer Specifications

Hello,

I have a Workbook with a lot of data in the worksheets, all the data in
each cell is a link I want to change it to regular text. I don't know much
about excel so please no advanced solutions please.

Thanks

's Computer Specifications

You can fix the values by highlighting the cells with formulae in and
click <copy> then Edit | Paste Special | Values (check) | OK | then
<Esc>.

Hope this helps.

Pete

On Feb 26, 6:01 am, "Just Me" <nob...@isp.com> wrote:
> Hello,
>
> I have a Workbook with a lot of data in the worksheets, all the data in
> each cell is a link I want to change it to regular text. I don't know much
> about excel so please no advanced solutions please.
>
> Thanks

's Computer Specifications

Didn't work ???
"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You can fix the values by highlighting the cells with formulae in and
> click <copy> then Edit | Paste Special | Values (check) | OK | then
> <Esc>.
>
> Hope this helps.
>
> Pete
>
> On Feb 26, 6:01 am, "Just Me" <nob...@isp.com> wrote:
>> Hello,
>>
>> I have a Workbook with a lot of data in the worksheets, all the data in
>> each cell is a link I want to change it to regular text. I don't know
>> much
>> about excel so please no advanced solutions please.
>>
>> Thanks
>
>

's Computer Specifications

Select the range
Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Just Me wrote:
>
> Hello,
>
> I have a Workbook with a lot of data in the worksheets, all the data in
> each cell is a link I want to change it to regular text. I don't know much
> about excel so please no advanced solutions please.
>
> Thanks

--

Dave Peterson

's Computer Specifications

Thank you, thank you , thank you !!!

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Select the range
> Hit alt-f11 to get to the VBE
> hit ctrl-g to see the immediate window
> type this and hit enter:
> selection.hyperlinks.delete
>
> Just Me wrote:
>>
>> Hello,
>>
>> I have a Workbook with a lot of data in the worksheets, all the data in
>> each cell is a link I want to change it to regular text. I don't know
>> much
>> about excel so please no advanced solutions please.
>>
>> Thanks
>
> --
>
> Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vista/Outlook2007-Button links in emails don't work,regular links	Windbag	Microsoft Outlook Discussion	0	7th Apr 2009 12:59 PM
Formula to change scientific number to regular number or text	=?Utf-8?B?Q29tcGFyZSBWYWx1ZXM=?=	Microsoft Excel Misc	2	23rd Aug 2007 06:10 PM
Text won't change back to Regular from Bold	fidtz@clara.co.uk	Microsoft C# .NET	5	20th Nov 2006 04:05 PM
How can I change a font from symbols to regular text	=?Utf-8?B?Um9kZWwgYmFyY2Vsb25h?=	Microsoft Word Document Management	2	8th Mar 2006 12:51 AM
How to change icon and text size from large to regular	Me	Windows XP Customization	1	19th Dec 2003 10:48 AM