Replace (') to space

A

Avadivelan TCS

Hi Dave Peterson,

Good Morning , Thanks a lot for your reply. that code is working well.
In that i am having one doubt, what is the use of vbLf ..?
And one more doubt: If the cell value starts with '987,'789,'12036,'1364, etc
I want to replce this character ( ' ) to space. please help me in this.
Thanks in advance.
 
D

Dave Peterson

You have a response at the other thread.

Avadivelan said:
Hi Dave Peterson,

Good Morning , Thanks a lot for your reply. that code is working well.
In that i am having one doubt, what is the use of vbLf ..?
And one more doubt: If the cell value starts with '987,'789,'12036,'1364, etc
I want to replce this character ( ' ) to space. please help me in this.
Thanks in advance.
 
Top