Convert Formula Column to Static URLs in Excel

I have a column that’s a formula from another column, and I deleted the the latter column because I don’t need it anymore. How can I turn the column shown in the screenshot into a pure url column rather than an output of the column I deleted?

9 comments

Channeled
APP
·
·
To convert a formula-based column into a pure URL column after deleting the source column: 1. Right-click on the column header 2. Select "Edit Column" > "Select Data Type" 3. Choose "URL" as the appropriate data type 4. Click "Save Settings" This will change the column's data type to URL, preserving the existing values without the formula dependency. If you need further assistance, please request human support by clicking on "Talk to a person" in the chat.
Sources: Select Column Data Type Table columns | Documentation | Clay University
Mike F.
·
·
no it’s already a url column. see screenshot.
Mike F.
·
·
Table: https://app.clay.com/workspaces/283560/tables/t_N55Ti4jCgmKk/views/gv_p45GwDBcXJ7f
Owen C.
·
·
Hey Michael, thanks for reaching out. Looking into this now. :)
Owen C.
·
·
Hey Michael, To remove the column inserted within the formula, simply: 1. Click on the column header 2. Select "Edit Column" 3. In the modal that appears on the right, find the column within the formula 4. Click into the text box and backspace to delete it You can see this process in the video below. :) Let me know if you need any further help!
Channeled
APP
·
·
Mike F.
·
·
If I delete it won’t I lose all the data that was populated by that field?
Bo (.
·
·
Hey Michael - Yes sorry for this. You can copy the column and paste it into a text column or you can export it as CSV and re-import it without any issue. Curious what were you trying to do exactly here with that data?
Channeled
APP
·
·