ST Alpha - "Are they hyperlinked (i.e. blue and underlined?) Un-hyperlink them first (that is, turn them to text) by..." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 154

In response to "help, please: is there an easy way to convert a list of e-mail addresses in excel to just names?" by b.

Are they hyperlinked (i.e. blue and underlined?) Un-hyperlink them first (that is, turn them to text) by...

Posted by Mop (still 235lbs... on a good day) (aka rburriel) Aug 5 '09, 10:41

...selecting each cell, right-clicking and choosing "Remove Hyperlink". Sorry, haven't found a way to do it to a whole range of cells yet.

By the way, I just tried replacing ".com" with BLANK and that worked (although, of course, they're still hyperlinked until I do the "Remove Hyperlink" thing).

Mop

Responses:

oh, duh. i did that for my first attempts, but then went back to the original. that may be why some other things didn't work. ok! off i go. -- nm - b. Aug 5, 10:44
copy range, paste special, text only. -- nm - loosilu Aug 5, 10:42 1
- (into a new column) -- nm - TFox Aug 5, 10:43

Post a message top

Are they hyperlinked (i.e. blue and underlined?) Un-hyperlink them first (that is, turn them to text) by...

Replies are disabled on threads older than 7 days.