If you are talking about the SPSS program, then I don't quite understand.
It sounds like you are looking at a variable in a dataset, and the value you see is "=1=red car".
If so, and it is a numeric variable, then you're looking at the value label for it, where 1 is supposed to be "red car".
Again, *if* we are talking about a value label, then perhaps you should edit it to clarify what 1 represents. See the VALUE LABELS command, or just edit them in the Variable View of the Data Editor.
------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------
Original Message:
Sent: Fri July 29, 2022 01:13 AM
From: Andranik Galstyan
Subject: How to remove =1=
Question, the cells contain the text =1= and then the answer, example:
=1= red car
In excel, I have to manually clean through ctrl+f
Is it possible to get rid of this with a script? what would the answer =1= red car be just a red car ?
------------------------------
Andranik Galstyan
------------------------------
#SPSSStatistics