How do I trim data from a field but data is not in all fields?

[Guest]

I want to trim data but not all the fields have the data?

 

[Guest]

Please provide examples of current data and what you wish it to look like
afterwards.

 

[John W. Vinson]

I want to trim data but not all the fields have the data?

Probably with an update query using the Replace function, updating the field
to

Replace([fieldname], "Data You Want Gone", "")

but it's awfully hard to be sure given the brevity of your question.

John W. Vinson [MVP]