How to replace X with the number 0

[rebel123]

Thanks for your help. I just need an equals sign equation please.

Here is the file. Or you can look at the screenshot.

Loading Google Sheets

 

[rebel123]

The correct answers are in the second column (column B)

 

[kweaver]

Try:

Book1
	A	B
1	01 04 41 0 005 049.XXX	01 04 41 0 005 049.000
2	01 04 42 0 000 018.XXX	01 04 42 0 000 018.000
3	01 04 44 1 000 007.01X	01 04 44 1 000 007.010
Sheet3

Cell Formulas
Range	Formula
B1:B3	B1	=SUBSTITUTE(A1,"X","0")

 

[rebel123]

Thanks works perfectly

 

[HazelHolcomb]

Try:

Book1
	A	B
1	01 04 41 0 005 049.XXX	01 04 41 0 005 049.000
2	01 04 42 0 000 018.XXX	01 04 42 0 000 018.000
3	01 04 44 1 000 007.01X	01 04 44 1 000 007.010
Sheet3

Cell Formulas
Range	Formula
B1:B3	B1	=SUBSTITUTE(A1,"X","0")

Thanks you made my day. Now, I can enjoy my day

 

[rebel123]

thanks!