Forum Discussion
Songbirdterry23
Sep 28, 2023Copper Contributor
Replace a decimal number with the number 1 in a spreadsheet
I have a large worksheet. one column has numbers like this:
0.00 4045197931 |
How can I delete the "0.00" and replace it with the number "1"?
it needs to read: 14045197931.
- OliverScheurichGold Contributor
=REPLACE(A1,1,5,"1")
You can try REPLACE if the values always start with a 0.00 pattern.
- SanthoshKunderIron ContributorO365 solution assuming there is always a space after 0.00 =1&TEXTAFTER(A1," ")