REPLACE FUNCTION_ change 3.000 to 3...
another possibility - just in case not all of your data has a decimal so you
can use find/replace.
select the column in question, change the format of the cells to general.
with your column still selected, click data/text to columns, select
delimited, click next, uncheck any delimiter options that may be checked,
click next, select general under the format options, click finish.
"Aline" wrote:
There's a column with results (1.000, 2.000, or 3.000, the Format Cells... is
Text) I would like to replace with 1, 2 or 3.
Is there a easier way to do it? I have tried =REPLACEB(A1, 2,4," "), but
it's not working. In the end I had to use Find function : find 3.000 and
replace 3; find 2.000 and replace 2, find 1.000 and replace 1.
(I've also tried change Format Cells from Text to General, and Number...)
A B
Level Obtained Level
3.000 3
2.000 2
2.000 2
3.000 3
1.000 1
Thanks,
Aline
--
Aline
|