From downloads I get a double apostrophe - impeding vlookups. I have tried
to do a find and replace, doing a find and replacing for anything else. It
will not work. I tried the right click tab editing and then it asks me to
save the new file. The new title will not take and I cannot close the file.

When I call up the Replace dialog box (Edit/Replace on menu bar or key in
Ctrl+H), put a double apostrophe in the "Find what" field and leave the
"Replace with" field blank, and then click the "Replace All" button, it
works fine for me.

Rick


"Marina Tuttle" wrote in message
...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me to
save the new file. The new title will not take and I cannot close the
file.

What is a double apostrophe? Is it quotation marks, if so that is not really
the same as 2 apostrophes?

--


Regards,


Peo Sjoblom


"Rick Rothstein (MVP - VB)" wrote in
message ...
When I call up the Replace dialog box (Edit/Replace on menu bar or key in
Ctrl+H), put a double apostrophe in the "Find what" field and leave the
"Replace with" field blank, and then click the "Replace All" button, it
works fine for me.

Rick


"Marina Tuttle" wrote in message
...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me
to
save the new file. The new title will not take and I cannot close the
file.

Hmm! I assumed the OP meant two apostrophes next to each other... it didn't
occur to me that she might have meant what everyone else calls a quote mark
when she said that. I would note, though, that the method I posted will work
for a quote mark as well as for two apostrophes next to each other.

Rick


"Peo Sjoblom" wrote in message
...
What is a double apostrophe? Is it quotation marks, if so that is not
really the same as 2 apostrophes?

--


Regards,


Peo Sjoblom


"Rick Rothstein (MVP - VB)" wrote in
message ...
When I call up the Replace dialog box (Edit/Replace on menu bar or key in
Ctrl+H), put a double apostrophe in the "Find what" field and leave the
"Replace with" field blank, and then click the "Replace All" button, it
works fine for me.

Rick


"Marina Tuttle" wrote in message
...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me
to
save the new file. The new title will not take and I cannot close the
file.

I believe if the data is imported it can be hard to get rid of the
apostrophe(s)/quotation mark(s) unless one uses
VBA or this method posted by Dave Peterson

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all


Maybe it will work for the OP's characters as well

--


Regards,


Peo Sjoblom

"Rick Rothstein (MVP - VB)" wrote in
message ...
Hmm! I assumed the OP meant two apostrophes next to each other... it
didn't occur to me that she might have meant what everyone else calls a
quote mark when she said that. I would note, though, that the method I
posted will work for a quote mark as well as for two apostrophes next to
each other.

Rick


"Peo Sjoblom" wrote in message
...
What is a double apostrophe? Is it quotation marks, if so that is not
really the same as 2 apostrophes?

--


Regards,


Peo Sjoblom


"Rick Rothstein (MVP - VB)" wrote
in message ...
When I call up the Replace dialog box (Edit/Replace on menu bar or key
in Ctrl+H), put a double apostrophe in the "Find what" field and leave
the "Replace with" field blank, and then click the "Replace All" button,
it works fine for me.

Rick


"Marina Tuttle" wrote in
message ...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me
to
save the new file. The new title will not take and I cannot close the
file.

Rick, I said apostrophe because it is a double apostrophe. How do I know?
If you hit backspace once, I keep one left. If I hit backspace twice, I get
totally rid off it. If it were a quote mark, you get rid of it in one swipe.

I will try your method and Peo's - thanks guys

"Rick Rothstein (MVP - VB)" wrote:

Hmm! I assumed the OP meant two apostrophes next to each other... it didn't
occur to me that she might have meant what everyone else calls a quote mark
when she said that. I would note, though, that the method I posted will work
for a quote mark as well as for two apostrophes next to each other.

Rick


"Peo Sjoblom" wrote in message
...
What is a double apostrophe? Is it quotation marks, if so that is not
really the same as 2 apostrophes?

--


Regards,


Peo Sjoblom


"Rick Rothstein (MVP - VB)" wrote in
message ...
When I call up the Replace dialog box (Edit/Replace on menu bar or key in
Ctrl+H), put a double apostrophe in the "Find what" field and leave the
"Replace with" field blank, and then click the "Replace All" button, it
works fine for me.

Rick


"Marina Tuttle" wrote in message
...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me
to
save the new file. The new title will not take and I cannot close the
file.

Peo, thanks for your time and help. I will try tomorrow and keep you posted
of the result.

Marina

"Peo Sjoblom" wrote:

I believe if the data is imported it can be hard to get rid of the
apostrophe(s)/quotation mark(s) unless one uses
VBA or this method posted by Dave Peterson

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all


Maybe it will work for the OP's characters as well

--


Regards,


Peo Sjoblom

"Rick Rothstein (MVP - VB)" wrote in
message ...
Hmm! I assumed the OP meant two apostrophes next to each other... it
didn't occur to me that she might have meant what everyone else calls a
quote mark when she said that. I would note, though, that the method I
posted will work for a quote mark as well as for two apostrophes next to
each other.

Rick


"Peo Sjoblom" wrote in message
...
What is a double apostrophe? Is it quotation marks, if so that is not
really the same as 2 apostrophes?

--


Regards,


Peo Sjoblom


"Rick Rothstein (MVP - VB)" wrote
in message ...
When I call up the Replace dialog box (Edit/Replace on menu bar or key
in Ctrl+H), put a double apostrophe in the "Find what" field and leave
the "Replace with" field blank, and then click the "Replace All" button,
it works fine for me.

Rick


"Marina Tuttle" wrote in
message ...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me
to
save the new file. The new title will not take and I cannot close the
file.

Just to add to Peo's response.

This would get rid of the apostrophe (prefixcharacter) for those cells that look
empty--but not the cells that actually have '' in them.

But that's just another edit|replace
Select the cells to fix
edit|replace
what: '
with: (leave blank)
replace all

Then do the edit|replace that Peo suggested.

Peo Sjoblom wrote:

I believe if the data is imported it can be hard to get rid of the
apostrophe(s)/quotation mark(s) unless one uses
VBA or this method posted by Dave Peterson

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all

Maybe it will work for the OP's characters as well

--

Regards,

Peo Sjoblom

"Rick Rothstein (MVP - VB)" wrote in
message ...
Hmm! I assumed the OP meant two apostrophes next to each other... it
didn't occur to me that she might have meant what everyone else calls a
quote mark when she said that. I would note, though, that the method I
posted will work for a quote mark as well as for two apostrophes next to
each other.

Rick


"Peo Sjoblom" wrote in message
...
What is a double apostrophe? Is it quotation marks, if so that is not
really the same as 2 apostrophes?

--


Regards,


Peo Sjoblom


"Rick Rothstein (MVP - VB)" wrote
in message ...
When I call up the Replace dialog box (Edit/Replace on menu bar or key
in Ctrl+H), put a double apostrophe in the "Find what" field and leave
the "Replace with" field blank, and then click the "Replace All" button,
it works fine for me.

Rick


"Marina Tuttle" wrote in
message ...
From downloads I get a double apostrophe - impeding vlookups. I have
tried
to do a find and replace, doing a find and replacing for anything else.
It
will not work. I tried the right click tab editing and then it asks me
to
save the new file. The new title will not take and I cannot close the
file.





--

Dave Peterson