=?Utf-8?Q?Removing_the_=E2=80=9C_from_a_cell?=

[MarkM]

How can I remove the “ (quotation) from the data in a cell? An example of
the data I have is: 3/8�X1/2� 18 GA GAL Staple. I need to remove the “ and
have the data look like 3/8X1/2 18 GA GAL Staple. The “ is causing a problem
with the import program I am using to import this into a third party program.

I have looked at the substitute function but can not get it to accept the “
as a valid old_text variable to remove.

Any help would be greatly appreciated.

Thanks

[Springbok]

Hi Mark,

Have you tried Find & Replace? Ctrl+H. Replace the " with nothing and it
should dissappear.
Cheers,
Jon

"MarkM" wrote:

> How can I remove the “ (quotation) from the data in a cell? An example of
> the data I have is: 3/8�X1/2� 18 GA GAL Staple. I need to remove the “ and
> have the data look like 3/8X1/2 18 GA GAL Staple. The “ is causing a problem
> with the import program I am using to import this into a third party program.
>
> I have looked at the substitute function but can not get it to accept the “
> as a valid old_text variable to remove.
>
> Any help would be greatly appreciated.
>
> Thanks
>

[MarkM]

Thanks Jon, I completely forgot about the find/replace. Sometimes the answer
is so easy that it eludes use.

Thanks again.


"Springbok" wrote:

> Hi Mark,
>
> Have you tried Find & Replace? Ctrl+H. Replace the " with nothing and it
> should dissappear.
> Cheers,
> Jon
>
> "MarkM" wrote:
>
> > How can I remove the “ (quotation) from the data in a cell? An example of
> > the data I have is: 3/8�X1/2� 18 GA GAL Staple. I need to remove the “ and
> > have the data look like 3/8X1/2 18 GA GAL Staple. The “ is causing a problem
> > with the import program I am using to import this into a third party program.
> >
> > I have looked at the substitute function but can not get it to accept the “
> > as a valid old_text variable to remove.
> >
> > Any help would be greatly appreciated.
> >
> > Thanks
> >