Want to treat e-mail addy as text!

[Mike]

I'm filling out a spreadsheet with e-mail addresses and things are
going fine; they are being treated as text which is what I want. I
don't know what I did, but when I tried to modify one addy, it turned
blue and brought up an e-mail entry with that addy in the TO: line.

What happened to make this a link and how do I undo it? Thanks - Mike

 

[JP]

1. Add a ' (single apostrophe) to the beginning of the cell and it should fix
this.
2. If you are comfortable with VBA, first select the cell, then in the
Immediate Window type in 'selection.hyperlinks.delete'


HTH,
JP

 

[Mike]

Sorry - the apostrophe has no effect - Mike

1. Add a ' (single apostrophe) to the beginning of the cell and it should fix
this.
2. If you are comfortable with VBA, first select the cell, then in the
Immediate Window type in 'selection.hyperlinks.delete'

HTH,
JP






- Show quoted text -

 

[JP]

My mistake, you need to remove the hyperlink first.

Right-click on the cell, choose "Remove Hyperlink"

Then

1. Hit F2 to edit the cell
2. 'Home' key to go to beginning of cell
3. Type ' (single apostrophe)

This should fix the cell. If you have a lot of cells to fix, highlight
them, then

1. Alt-F11 to open the VB Editor
2. Ctrl-G to open Immediate Window
3. Type "selection.hyperlinks.delete" (without quotes) and hit Enter


HTH,
JP

 

[Mike]

My mistake, you need to remove the hyperlink first.

Right-click on the cell, choose "Remove Hyperlink"

Then

1. Hit F2 to edit the cell
2. 'Home' key to go to beginning of cell
3. Type ' (single apostrophe)

This should fix the cell. If you have a lot of cells to fix, highlight
them, then

1. Alt-F11 to open the VB Editor
2. Ctrl-G to open Immediate Window
3. Type "selection.hyperlinks.delete" (without quotes) and hit Enter

HTH,
JP





- Show quoted text -

JP - thanks, that worked - Mike