VBA question

P

PeCoNe

Cell A52 contains the text:

AEX*: 352,54 +1,65 +0,47% O: 351,84 H: 352,66 L: 351,84 C: 350,89

How can i substitute "," by "." in VBA

SUBSTITUTE(A52,",",".") does not work
 
C

Claus Busch

Hi,

Am Mon, 21 Jan 2013 14:40:42 +0100 schrieb PeCoNe:
Cell A52 contains the text:

AEX*: 352,54 +1,65 +0,47% O: 351,84 H: 352,66 L: 351,84 C: 350,89

How can i substitute "," by "." in VBA

SUBSTITUTE(A52,",",".") does not work
Click to expand...

try Replace


Regards
Claus Busch
 
R

Ron Rosenfeld

Cell A52 contains the text:

AEX*: 352,54 +1,65 +0,47% O: 351,84 H: 352,66 L: 351,84 C: 350,89

How can i substitute "," by "." in VBA

SUBSTITUTE(A52,",",".") does not work
Click to expand...

worksheetfunction.substitute( ...

or

replace
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split text field in VBA 19
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Dealing with the error: unable to filter on excel hc home school 0
Copy addition formula of non-consecutive horizontal cells 2
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Multiple items selected multiple dependancies available 3
limits to multiple subsitute funtion?? 12

Top