Removing extra spaces after decimal point

[Macfifteen]

I have an excel spreadsheet I imported. Most of the data came in fine, but some has an extra space after the decimal point. I tried TRIM but that didn't work. How can I remove these? Thanks for the help.

	13	32	33	34	35	36	37	37	39	40
76	89.0	88.5	88.1	87.6	87.2	86.8	86.3	85.9	85.4	85.0
77	89. 9	89.4	89.0	88.5	88.1	87.7	87.2	86.8	86. 3	85.9
78	90.9	90.4	90.0	89.5	89.1	88.7	88.2	87.8	87.3	86.9
79	91.8	91.3	90.9	90.4	90.0	89.6	89.2	88.7	88.3	87.9
80	92. 7	92.3	91.8	91.4	91.0	90. 6	90.1	89.7	89.2	88.8
81	93.7	93.2	92.8	92.3	91.9	91.5	91.0	90.6	90.1	89.7
82	94 6	94 2	93.7	93.3	92.9	92.5	92.0	91.6	91.1	90. 7
83	95.6	95.1	94 7	94 3	93.9	93.5	93.0	92. 6	92. 1	91.7
84	96.4	96.0	95.6	95.2	94 8	94.4	94 0	93. 5	93.1	92.7
85	97.4	97.0	96.5	96.1	95.7	95.3	94 9	94 5	94.1	93.7
86	98.3	97.9	97.5	97.1	96.7	96.3	95.9	95.4	95.0	94 6
87	99. 3	98.9	9a 4	98.0	97.6	97.2	96.8	96.4	96.0	95.6
88	100.3	99.9	99.4	99.0	98.6	98.2	97.8	97.3	96.9	96.5
89	101.2	100.8	100.3	99.9	99.5	99.1	98.7	98.3	97.9	97.5
90	102.1	101.7	101.3	100.9	100.5	100.1	99.7	99.2	98.8	98.4

<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> <col width="65" span="10" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

 

[Fishboy]

Will a Find / Replace not suffice?

Ctrl+H
Find ". " (without speech marks)
Replace with "." (without speech marks)

 

[Asala42]

Can you get away with just doing a mass Edit->Replace? It looks like all the spaces in your sample would be undesirable.

1) Select Range
2) Ctrl+H (or use menu options under the Home Tab -> "Find and Select" -> Replace)
3) Type a space in the "find what" box, nothing in the other one
4) Hit Replace all.

 

[Fishboy]

Can you get away with just doing a mass Edit->Replace? It looks like all the spaces in your sample would be undesirable.

1) Select Range
2) Ctrl+H (or use menu options under the Home Tab -> "Find and Select" -> Replace)
3) Type a space in the "find what" box, nothing in the other one
4) Hit Replace all.

I dont know if it was a typo, but there is at least one value in the example grid which had a space but no decimal point. Your suggestion would turn "94 6" to "946". To be safe it would be better to replace ". " with "."

 

[Mackers]

To avoid the "94 6" error, you could find all the spaces and replace them with decimal points, then find all the double decimal points and replace them with single decimal points. The thing to watch out for then would be a space after a number after a decimal, as say if your original data was "9.46 " my method would turn it to "9.46.").

 

[Macfifteen]

Fishboy

That worked great. Thank you.

 

[Fishboy]

Fishboy

That worked great. Thank you.

Happy to help.