Replace a decimal number with the number 1 in a spreadsheet

Copper Contributor

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.

2 Replies

@Songbirdterry23 

=REPLACE(A1,1,5,"1")

You can try REPLACE if the values always start with a 0.00 pattern.

replace.png

 

O365 solution assuming there is always a space after 0.00 =1&TEXTAFTER(A1," ")