Arvi Laanemets wrote:
Hi

I just tried with Find and Replace

Replace All " with nothing entered removes all " from sheet/range
Replace All "" with nothing entered removes all "" from sheet/range,
but
entries like " or " " remain unchanged.


Arvi Laanemets



"Nurddin" wrote in message
m...
Hi,

I need to find double quotes in an excel file (could be a selectoin
of
rows) and replace them with nothing ( yeah just want to delete
them)

The built in Excel function to Find and Replace all gives me error
"formula too long"

Can someone please write me a small macro code

thanks