Forum Discussion
NClarke3
Sep 11, 2023Copper Contributor
Change values on data sheet
Hi I need to change values from 1,2,3,4 to 0,1,2,3 on an entire data sheet. What is the best way to do this please? Thanks in advance.
SergeiBaklan
Sep 11, 2023Diamond Contributor
If that's something like this
you may enter -1 in any empty cell, copy it, select your range and Paste->Paste special->Add->Ok
Delete -1 from the helper cell. Result is
If something like this
when one by one. Select nothing, Ctrl+H, match entire cell content, Replace All.
- NClarke3Sep 16, 2023Copper ContributorThank you.