Excel Problem Help.

[DOMiNIC]

I wasn't really sure where to post this question.

I often cut and paste data bases from, for example, Sedo or my Name Drive account to Excel.

In the Excel column that contains domain names they each appear as underlined Hyperlinks.

You can right click on each hyperlink individually and remove the hyperlink, but I'll be damned if I can find a shortcut method to remove all the hyperlinks in one sweep.

To right click and remove each hyperlink individually on a list of thousands is a real time consuming bummer.

I'm not a complete dummy (tell me if you disagree). My windows is installed in Spanish so I'm compatible with the rest of my office, and as Spanish is only my second language, I find it hard to search trouble shooting in Spanish. That said even my webmaster can't find a solution to this vey annoying problem.

10 N.P.s to the first person to find a solution.

Thank You.

DOMiNIC

 

[Mr. Websites]

You could try this to eliminate the automatic creation of hyperlinks. Or you could:
1. Hold down "Control" key and select all the Hyperlinks.
2. Go to "Edit" menu and select the option "Clear."
3. Now select the "Formats" Option.
Alternatively, you could try the "pasting technique" to eliminate hyperlinks.
Let me know if either of these is what you're looking for.

 

[DOMiNIC]

Thanx Mr Websites.

Very helpful.

15 N.P.s on the way as you responded very quickly with three sugestions.

Rep Too.

Muchas Gracias

DOMiNIC

 

[Mr. Websites]

Thank-you DOMiNIC, reputation points added as well! :music:

 

[DOMiNIC]

Thank-you DOMiNIC, reputation points added as well! :music:

That's why I want to also say thank you to R.J. and all the staff and mods. who make Name Pro's a 'Win/Win' forum for everybody.