VBA, Substitute, Find and Replace, Trim Not working to remove space

[CM_1995]

Hi All;

I have a file and the numbers have a blank space at the end of the character.

I have tried trim, substitute, macros and find and replace to remove this but nothing works.
e.g.
=SUBSTITUTE(E5," ","")
=Trim(CLEAN(E3))
=Value(e5)

Sub Replace_Example1()
Range("E3:J78").Replace What:=" ", Replacement:=""
End Sub

Sub
Worksheets("Sheet1").Columns("E").Replace _ What:=" ", Replacement:="", _ SearchOrder:=xlByColumns, MatchCase:=True
End Sub

I have also tried changing the format from "general" to "number" and copying and pasting the results of the formulas as values.

Note:
- all functions work to remove or replace " "on text that is placed alongside side the numbers in the same file but not the numbers themselves.
-Find and replace works when one single cell is highlighted at a time.
- no error notification appears to allow me to "convert to number"

Example Data.xlsx
	D	E	F	G	H	I	J
2		Total to be delivered	2018/2019	2019/2020	2020/2021	2021/2022	2022/2023
3	Example data 1	14	8	2	1	1	2
4	Example data 2	1	0	1	0	0	0
5	Example data 3	10	2	1	1	1	1
6	Example data 4	4	3	0	0	0	1
7	Example data 5	11	4	1	1	1	1
8	Example data 6	120.53	100	0	0	0	0
9	Example data 7	60.22	0	5	5	5	5
10	Example data 8	1	0	0	0	0	1
11	Example data 9	3	0	1	1	1	0
12	Example data 10	1	0	0	0	1	0
13	Example data 11	4	4	0	0	0	0
14	Example data 12	1	1	0	0	0	0
15	Example data 13	100	75	0	0	0	0
16	Example data 14	100	75	0	0	0	0
17	Example data 15	4	1	1	1	0	0
18	Example data 16	1
19	Example data 17	4		2	0	0	0
20	Example data 18	10		2	1	1	1
21	Example data 19	100		50	0	0	0
22	Example data 20	300		0	50	50	50
23	Example data 21	8		1	1	1	1
24	Example data 22	8		1	1	1	1
25	Example data 23	16		2	2	2	2
26	Example data 24	20		3	3	3	3
27	Example data 25	15		3	2	2	2
28	Example data 26	8		1	1	1	1
29	Example data 27	8		1	1	1	1
30	Example data 28	32		4	4	4	4
31	Example data 29	10		2	1	1	1
32	Example data 30	75		5	10	10	10
33	Example data 31	4		1	1	0	0
34	Example data 32	10		2	1	1	1
35	Example data 33	100		50	0	0	0
36	Example data 34	300		0	50	50	50
37	Example data 35	8		1	1	1	1
38	Example data 36	8		1	1	1	1
39	Example data 37	8		1	1	1	1
40	Example data 38	16		2	2	2	2
41	Example data 39	20		3	3	3	3
42	Example data 40	12		2	2	2	2
43	Example data 41	8		4	2	2	0
44	Example data 42	64		5	10	10	10
45	Example data 43	10		1	2	2	2
46	Example data 44	20		2	2	2	5
47	Example data 45	5		1	2	0	0
48	Example data 46	2		1	1	0	0
49	Example data 47	3		0	0	1	1
50	Example data 48	8		0	2	2	2
51	Example data 49	2000		0	750	750	0
52	Example data 50	2000		0	0	750	750
53	Example data 51	4		0	1	1	1
54	Example data 52	4		0	1	1	1
55	Example data 53	4		0	1	1	1
56	Example data 54	14		2	2	2	2
57	Example data 55	100		0	0	50	50
58	Example data 56	24		3	3	3	3
59	Example data 57	8		0	0	2	2
60	Example data 58	3		2	0	0	0
61	Example data 59	30000		0	7500	7500	7500
62	Example data 60	4		1	1	1	1
63	Example data 61	2000		0	0	750	750
64	Example data 62	8	8	0	0	0	0
65	Example data 63	1	1	0	0	0	0
66	Example data 64	1	1	0	0	0	0
67	Example data 65	370	250	20	20	20	20
68	Example data 66	5	0	5	0	0	0
69	Example data 67	4	2	0	0	0	2
70	Example data 68	3	2	1	0	0	0
71	Example data 69	8	4	1	1	1	1
72	Example data 70	8	4	1	1	1	1
73	Example data 71	10	2	1	1	1	1
74	Example data 72	110	0	60	10	10	10
75	Example data 73	4	4	0	0	0	0
76	Example data 74	5	5	0	0	0	0
77	Example data 75	10	2	2	2	2	2
78	Example data 76	20	0	2	2	2	2
Sheet1

 

[Alex Blakenburg]

Try
ActiveSheet.UsedRange.Replace What:=ChrW(8203), Replacement:="", LookAt:=xlPart

And if that doesn't work
ActiveSheet.UsedRange.Replace What:=ChrW(160), Replacement:="", LookAt:=xlPart

 

[Cubist]

If neither of Alex's suggestions work, you can use a formula to diagnosis the rouge character(s) as follows:

Book1
	E	F	G	H
5	14		1	49
6			4	52
7				160
Sheet2

Cell Formulas
Range	Formula
G5:G7	G5	=MID(E5,SEQUENCE(LEN(E5)),1)
H5:H7	H5	=UNICODE(G5#)
Dynamic array formulas.

 

[CM_1995]

Thankyou @Alex Blakenburg the below worked.

ActiveSheet.UsedRange.Replace What:=ChrW(160), Replacement:="", LookAt:=xlPart

 

[Alex Blakenburg]

You're welcome. Glad we could help.