PC Review


Reply
Thread Tools Rate Thread

How to change links to regular text

 
 
Just Me
Guest
Posts: n/a
 
      26th Feb 2007
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


 
Reply With Quote
 
 
 
 
Pete_UK
Guest
Posts: n/a
 
      26th Feb 2007
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



 
Reply With Quote
 
Just Me
Guest
Posts: n/a
 
      26th Feb 2007
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

>
>



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      26th Feb 2007
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
 
Reply With Quote
 
Just Me
Guest
Posts: n/a
 
      26th Feb 2007
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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:26 AM.