Replace function for partial characters

[GerrardSVK]

Hi everyone could someone help me I just need to write simple macro that will change number from this format: 1.234 into format using comma instead of dot : 1,234
Also I need to change sign of degrees into nothing. So if there will be some number like this 1.234° final result will be 1,234.

I tried this but dont work:
Sub Replace()

Workbooks(2).ActiveSheet.Range("G9:G136").Replace What:=".", Replacement:=","
Workbooks(2).ActiveSheet.Range("G9:G136").Replace What:="°", Replacement:=""

End Sub

I think there have to be additional xlPart defined or something.

 

[GerrardSVK]

OK. I'm not sure that I can be of any further assistance. The file you shared is a comma delimited csv with all the values in column A - I'm not sure what process you undertake to get those values into column G so as to match your original post requirements. In any event, I ran the code on column A to see whether it would remove the degree symbol & convert the periods to commas - and it seemed to. Therefore, I cannot duplicate the issue you're having with the code. Here's a link to the file you shared after I ran the code on column A.
1.kus_kavita.csv

Try it on these columns

 

[kevin9999]

Try it on these columns

I can't copy an image into a sheet. Can you post the above using the XL2BB add in?

 

[GerrardSVK]

I can't copy an image into a sheet. Can you post the above using the XL2BB add in?

it is in that file you already have 1.kus cavity
just aply your code on it for different colums

 

[kevin9999]

it is in that file you already have 1.kus cavity
just aply your code on it for different colums

As I said previously

The file you shared is a comma delimited csv with all the values in column A

It's not the same thing at all.

 

[GerrardSVK]

As I said previously

It's not the same thing at all.

yes you are right its not corect so thats why I told you to aply it on that diferent colums(D9:D136) where decimal numbers are divided by dot

 

[kevin9999]

yes you are right its not corect so thats why I told you to aply it on that diferent colums(D9:D136) where decimal numbers are divided by dot

But there's nothing in those columns. They are blank. For the 3rd time, all the values are in column A, comma delimited (semi colon in your region settings it seems) so I would be applying the code to blank columns.

 

[GerrardSVK]

But there's nothing in those columns. They are blank. For the 3rd time, all the values are in column A, comma delimited (semi colon in your region settings it seems) so I would be applying the code to blank columns.

Oh sorry so there is probably something wrong with file I try tu send you new one:

Try this one there should be values with dot in column G9-G136

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com

 

[kevin9999]

You need to make the file available to anyone with the link.

 

[GerrardSVK]

You need to make the file available to anyone with the link.

2.kus_kavita3.csv

drive.google.com

 

[kevin9999]

OK I ran the code on column D (D9:D136).
Before:

2.kus_kavita3.xlsx
	D
9	73.300°
10	5.5
11	51.6
12	48
13	38.3
14	36.95
15	0
16	30
17	0
18	29
19	20.8
20	16.3
21	10.4
22	6
23	6
24	10
25	2
26	16
27	22.6
28	1.9
29	16.4
30	10.1
31	0
32	6
33	6
34	10.4
35	16.2
36	10
37	16
38	22.6
39	1.9
40	30
41	9
42	2
43	0
44	0
45	0
46	0
47	0
48	16.3
49	10.4
50	6
51	6
52	10
53	2
54	16
55	22.6
56	1.9
57	16.4
58	10.1
59	0
60	6
61	6
62	10.4
63	16.2
64	10
65	16
66	22.6
67	1.9
68	30
69	9
70	2
71	0
72	0
73	0
74	0
75	0
76	16.15
77	21.4
78	12
79	11.5
80	25
81	17
82	1.8
83	21.5
84	15.9
85	0
86	2.3
87	12
88	12
89	16.3
90	21.3
91	11.5
92	17
93	25
94	1.8
95	30
96	3.7
97	12.7
98	12
99	2.7
100	0
101	0
102	0
103	0
104	0
105	13.9
106	11.9
107	11
108	11.7
109	0.8
110	0.8
111	30.000°
112	3
113	1.2
114	90.000°
115	2.8
116	2.8
117	24.9
118	25.8
119	27.8
120	21
121	11.2
122	13.1
123	13.9
124	14
125	6
126	12
127	4
128	3.25
129	250
130	116.3
131	58.6
132	252.7
133	62.3
134	142.5
135	2.9
136	2.9
2.kus_kavita3

After:

2.kus_kavita3.xlsx
	D
9	73,300
10	5,5
11	51,6
12	48
13	38,3
14	36,95
15	0
16	30
17	0
18	29
19	20,8
20	16,3
21	10,4
22	6
23	6
24	10
25	2
26	16
27	22,6
28	1,9
29	16,4
30	10,1
31	0
32	6
33	6
34	10,4
35	16,2
36	10
37	16
38	22,6
39	1,9
40	30
41	9
42	2
43	0
44	0
45	0
46	0
47	0
48	16,3
49	10,4
50	6
51	6
52	10
53	2
54	16
55	22,6
56	1,9
57	16,4
58	10,1
59	0
60	6
61	6
62	10,4
63	16,2
64	10
65	16
66	22,6
67	1,9
68	30
69	9
70	2
71	0
72	0
73	0
74	0
75	0
76	16,15
77	21,4
78	12
79	11,5
80	25
81	17
82	1,8
83	21,5
84	15,9
85	0
86	2,3
87	12
88	12
89	16,3
90	21,3
91	11,5
92	17
93	25
94	1,8
95	30
96	3,7
97	12,7
98	12
99	2,7
100	0
101	0
102	0
103	0
104	0
105	13,9
106	11,9
107	11
108	11,7
109	0,8
110	0,8
111	30,000
112	3
113	1,2
114	90,000
115	2,8
116	2,8
117	24,9
118	25,8
119	27,8
120	21
121	11,2
122	13,1
123	13,9
124	14
125	6
126	12
127	4
128	3,25
129	250
130	116,3
131	58,6
132	252,7
133	62,3
134	142,5
135	2,9
136	2,9
2.kus_kavita3