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.
SanthoshKunder
Sep 29, 2023Iron Contributor
O365 solution assuming there is always a space after 0.00 =1&TEXTAFTER(A1," ")