How to remove spaces and periods in a single cell

[rebel123]

correct answers are in green. I just need an equals sign equation for the answer.
Thanks!

 

[rebel123]

file is here-

https://docs.google.com/spreadsheets/d/1JYW3il1HuX6MqLVRTdoioI34Ct1ftm9S/

 

[FormR]

Hi, here's one way you can try.

Book3
	A	B
1	22 00 01 4 004 022.000	2200014004022000
2	30 00 02 2 006 005.000	3000022006005000
3	13 00 31 3 001 019.000	1300313001019000
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=CONCAT(TEXTSPLIT(A1,{" ","."}))

 

[FormR]

BTW, your file share didn't work..

 

[rebel123]

Thanks so much! Sorry my file share did not work, but you solved the problem!

 

[jolivanes]

If you don't have "TextSplit"

=substitute(substitute(A2, " ",""),".","")