I have a field in SQL Server table that somehow got data altered. So the data reads like this Test ,Test Is there a way for me to run an update query which will modify the data back to the original formatting of Test, Test?

Try this:
update mytable
set mycolumn = replace(mycolumn, ' ,', ',')

This will replace ' ,' with just a single comma. And of course mytable = your table name and mycolumn = your field name.