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
|