View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

If you just want to change the text displayed in the cell:

Dim Cell As Range
For Each Cell In Selection
Cell.Value = "www." & Cell.Value & ".com"
Next


--
Jim
"BenJAMMIN" wrote in message
...
|
| If you would like to permanently display the path in the
| cell (i.e. replace microsoft with www.microsoft.com), right click on the
| cell, and use edit hyperlinks. The top pane shows the display name, the
| bottom pane shows the path. Copy the path to the display name. I am not
| sure if there is a quick way to do this. NOTE: You will have to use
keyboard
| commands to copy and paste.
|
| This solution works, but it is one by one. Does anyone k now of a mass
| change method? I want to take a hyperlinked word (web address or email
| address) and have it display the hyperlink properties instead of the word.