Excel - COLUMN Function Problem - Expert Solution

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
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc