There’s no way to edit/remove part of string, you just need to update whole cell. It’s up tou you, how you’ll prepare update data in your code.
SQL:
update tablename set Value="A1 A2" where ID=1
solved How to delete the specific database value [closed]