Hello,

How can i count Count Space, comma and fullstop in a string through macro.

For Ex. if A1= My name is Rahul. Then B1=4
For Ex. if A1= My name is Rahul, my brother's name is NewName & our surname
is Gupta. Then B1 =14

and so on.

Thanks in advance,

Rahul