how to write a program in excel using visual Basic

[sunnyfunghy]

Hi everyone,

how to write a program below in excel using visual Basic

1. Write a program to calculate
(i) the total number of characters (excluding punctuation marks) in each cell in an Excel file
(ii) the number of characters before the first occurrence of "，"

For example:
ABCDE,FGH.

Answer
1i) 8
2)5

Many thanks^^

 

[qieda]

do you want to use VBasic, or would it be ok to use excel functions

e.g.
if your string is in cell A1
=LEN(A1) gives the length of 8
=SEARCH(",",A1)-1 gives the length of 5

regards

 

[sunnyfunghy]

do you want to use VBasic, or would it be ok to use excel functions

e.g.
if your string is in cell A1
=LEN(A1) gives the length of 8
=SEARCH(",",A1)-1 gives the length of 5

regards

Thank you
but if like this, and I want to do in visual Basic
e.g. abcde,bcdef,jkl.

Total: 13 before "." and excluding "."
Thanks a lot^^

---------- Post added at 11:09 ---------- Previous post was at 10:09 ----------

Besides, I also discover that when "=SEARCH(",",A1)-1" this command code uses to count Chinese word, there is an error. So how to change?

Many thanks