Hi All,

I need a VB code to remove all leading single quotes from all cells in a worksheet.
The cells may or may not contain quotes. Some of the cells contains alpha numeric,dates,numeric with leading zeros. i want to retain those zeros as well.
ex: '01234 as 1234
'qwerty12345 as qwerty12345
'02/12/2015 as 02/12/2015

I tried by using excel formula "SUBSTITUTE(cell reference,CHAR(39),"")". its working well but i need to do this for the entire worksheet where ever there is a leading single quote.
Any help is greatly appreciated.



Thanks
Shreeja