I have a long spreadsheet and in one column, I need to:
1) find all numbers which are -1 and lower, and replace with just the number "-1"
2) leave "0" as "0"
3) find all numbers which are +1 and higher, and replace with just the number "1".
Here's part of the spreadsheet:
209
117
-218
274
237
0
-123
-36
12
etc ...
I've searched and searched, but have not found a solution yet. Any help would be GREATLY appreciated!
Bookmarks