Deleting a specific value from a column

How can I delete just one value in a column. for instance : I have Name column with value TEST on some records, so I just want only these to delete. Thanks in advance.

Filter the records on that value. Then remove that value from each of those records.

Filter your list based on the TEST, then Edit in Excel (use the Search if you don’t see it). This will allow you to update (clear) in bulk the field you want, then publish the results back to Business Central. Be aware, the process will dump all the fields, but the Name field will be near the beginning.
image

image

Thank you everyone for your help <3