Question description:
This user has given permission to use the problem statement for this
blog.
when setting up a spread sheet my email column is a live link. How can i make it data. I don't need it to be a link. Thanks
Solved by D. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/03/2018 - 05:33
Welcome to excel got it pro.
Excelchat Expert
02/03/2018 - 05:33
I understand you want help with removing hyperlinks from email addresses right?
User
02/03/2018 - 05:34
yes hyperlinks!
Excelchat Expert
02/03/2018 - 05:34
Okay, I presume your emails addresses are in one column. Please select that column.
User
02/03/2018 - 05:35
yes
Excelchat Expert
02/03/2018 - 05:35
Then right click on your mouse, you will see an option named, "remove hyperlinks". clicking on it will do the trick.
User
02/03/2018 - 05:36
macbook
Excelchat Expert
02/03/2018 - 05:36
okay, 1 sec.
Excelchat Expert
02/03/2018 - 05:37
To remove a hyperlink, select the item in your file, go to the Insert tab of the ribbon and click Link > Remove Link.
Excelchat Expert
02/03/2018 - 05:38
still problem?
Excelchat Expert
02/03/2018 - 05:40
If that doesn't help, follow this >> Select the Column, Go to the Edit Menu>Clear>Hyperlinks
User
02/03/2018 - 05:41
web page document email address
Excelchat Expert
02/03/2018 - 05:42
Sorry?
Excelchat Expert
02/03/2018 - 05:42
can you send me the file?
User
02/03/2018 - 05:43
only choices
User
02/03/2018 - 05:43
All format content comments
Excelchat Expert
02/03/2018 - 05:43
is it excel for mac? or other program?
User
02/03/2018 - 05:44
got it thank y you very much!! just had to keep clicking :) bye
Excelchat Expert
02/03/2018 - 05:44
Please close session before you go.
Excelchat Expert
02/03/2018 - 05:44
To close session click on the end session button.
Excelchat Expert
02/03/2018 - 05:44
Have a great day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.