Hi, how can I just delete the text values in this workbook where it says Not Available? https://app.clay.com/workspaces/670253/workbooks/wb_0sz6ugaxRpWDQC9QBfm/tables/t_0t0bg5ixS4ysTk4kEU4/views/gv_0sz6ugahV3D6yAkmBS3 That workbook is a copy of this one, which has the formulas that produced the "Not Available" values https://app.clay.com/workspaces/670253/workbooks/wb_0sz6ugaxRpWDQC9QBfm/tables/t_0szaay9t77oqp6dPbvM/views/gv_0sz6ugahV3D6yAkmBS3
To delete text values that say "Not Available" in your workbook, you have two options: Option 1: Filter and delete rows 1. Click Filter above the table 2. Select the column containing "Not Available" 3. Choose equal to and enter "Not Available" 4. This will show only rows with "Not Available" - you can then delete these rows Option 2: Delete the entire column 1. Right-click the column containing "Not Available" 2. Click Delete > Delete Column The filter method lets you target specific cells, while deleting the column removes all data in that column.
Ok, but I do not want to delete the entire row or the entire column
To edit individual cells containing "Not Available": Option 1: Direct editing ** Click on each cell with "Not Available" and directly copy/paste the correct value or delete the content Option 2: Use search to find cells 1. Click the Search Bar at the top of your table 2. Enter "Not Available" and press *Search 3. Use navigation arrows to move between matches 4. Edit each highlighted cell individually This lets you target specific cells without affecting entire rows or columns.
I want to get the value blank and then make it possible to edit those cells in bulk
Do you know what I mean?
To make "Not Available" cells blank for bulk editing: 1. Filter for "Not Available": Click Filter above the table, select your column, choose "equal to" and enter "Not Available" 2. Select and clear: Once filtered, you can select multiple cells showing "Not Available" and delete their content to make them blank 3. Remove filter: Clear the filter to see all rows again with those cells now blank and ready for bulk editing This approach lets you target only the "Not Available" cells without affecting other data in the rows or columns.
Ok, good, and once I filter them to only see "Not Available" cells, how can I then actually delete them without wrecking the table itself? I just want the cells where "Not Available" is to be blank, so that we can run the formulas again with no problem.
Once you've filtered to show only "Not Available" cells: 1. Select the filtered cells: Click and drag to select all the visible "Not Available" cells in your filtered view 2. Delete content: Press the Delete key or Backspace to clear the cell contents 3. Clear filter: Remove the filter to return to your full table view The cells will now be blank and ready for formulas to run again. This method only clears the cell content without affecting the table structure or other data.
I want to delete them all
Do you know what I mean?
To select and delete all filtered "Not Available" cells at once: 1. After filtering to show only "Not Available" cells, click on the column header to select the entire filtered column 2. Press Delete or Backspace to clear all visible cells simultaneously 3. Remove the filter to return to your full table view This will clear all "Not Available" cells in one action rather than selecting 10 at a time.
I do not quite understand what you mean.
