P
Paul B
I have a column of data in the form of 1-1, 1-2, … 1-123, it has a space at
the end of the numbers, not really a space, I can copy the "space" and paste
it in another cell and then use = code and I get a code of 160. how can I
get this out from behind all the data in column B. I have copied the "space"
and did a replace on the column but then all the cells format as a date,
even if I format the column to text first. How can I do this and not have
the data change to a date?
the end of the numbers, not really a space, I can copy the "space" and paste
it in another cell and then use = code and I get a code of 160. how can I
get this out from behind all the data in column B. I have copied the "space"
and did a replace on the column but then all the cells format as a date,
even if I format the column to text first. How can I do this and not have
the data change to a date?