I have an Excel spreadsheet with a column of 825 numbers. These numbers were
put in with the preceding apostrophe so Excel recognizes the numbers as text.
The spreadsheet was probably created with an older version of Excel.
I need to get the apostrophes (') out of the cells as I have to import the
whole spreadsheet into a certain program, which cannot read the symbol, and
thus the import fails. Formatting the cells to Text does not work, nor does
General, as the ' was typed into the cells. I tried to use Find and Replace,
but that didn't work for me.
Is there a way to maybe use a formula to get only the apostrophe out of the
825 cells?
Any help will be greatly appreciated.

One way:

Copy an empty cell. Select your 825 cells. Choose Edit/Paste Special,
selecting the Values and Add radio buttons. Click Next.

In article <B46E2ABE-74BA-4980-A847-(E-Mail Removed)>,
Hilde <(E-Mail Removed)> wrote:

> I have an Excel spreadsheet with a column of 825 numbers. These numbers were
> put in with the preceding apostrophe so Excel recognizes the numbers as text.
> The spreadsheet was probably created with an older version of Excel.
> I need to get the apostrophes (') out of the cells as I have to import the
> whole spreadsheet into a certain program, which cannot read the symbol, and
> thus the import fails. Formatting the cells to Text does not work, nor does
> General, as the ' was typed into the cells. I tried to use Find and Replace,
> but that didn't work for me.
> Is there a way to maybe use a formula to get only the apostrophe out of the
> 825 cells?
> Any help will be greatly appreciated.

Thank you, JE. Unfortunatley, I don't have the option to Add radio buttons. I
am working with Excel 2002 SP3. Sorry, I should have clarified that in my
question.

"JE McGimpsey" wrote:

> One way:
>
> Copy an empty cell. Select your 825 cells. Choose Edit/Paste Special,
> selecting the Values and Add radio buttons. Click Next.
>
> In article <B46E2ABE-74BA-4980-A847-(E-Mail Removed)>,
> Hilde <(E-Mail Removed)> wrote:
>
> > I have an Excel spreadsheet with a column of 825 numbers. These numbers were
> > put in with the preceding apostrophe so Excel recognizes the numbers as text.
> > The spreadsheet was probably created with an older version of Excel.
> > I need to get the apostrophes (') out of the cells as I have to import the
> > whole spreadsheet into a certain program, which cannot read the symbol, and
> > thus the import fails. Formatting the cells to Text does not work, nor does
> > General, as the ' was typed into the cells. I tried to use Find and Replace,
> > but that didn't work for me.
> > Is there a way to maybe use a formula to get only the apostrophe out of the
> > 825 cells?
> > Any help will be greatly appreciated.
>

He meant that you should select add in the paste special options, those
round circles that you can select are called radio buttons (or options
buttons)


--
Regards,

Peo Sjoblom




"Hilde" <(E-Mail Removed)> wrote in message
newsD730D26-069E-47A7-85CB-(E-Mail Removed)...
> Thank you, JE. Unfortunatley, I don't have the option to Add radio
> buttons. I
> am working with Excel 2002 SP3. Sorry, I should have clarified that in my
> question.
>
> "JE McGimpsey" wrote:
>
>> One way:
>>
>> Copy an empty cell. Select your 825 cells. Choose Edit/Paste Special,
>> selecting the Values and Add radio buttons. Click Next.
>>
>> In article <B46E2ABE-74BA-4980-A847-(E-Mail Removed)>,
>> Hilde <(E-Mail Removed)> wrote:
>>
>> > I have an Excel spreadsheet with a column of 825 numbers. These numbers
>> > were
>> > put in with the preceding apostrophe so Excel recognizes the numbers as
>> > text.
>> > The spreadsheet was probably created with an older version of Excel.
>> > I need to get the apostrophes (') out of the cells as I have to import
>> > the
>> > whole spreadsheet into a certain program, which cannot read the symbol,
>> > and
>> > thus the import fails. Formatting the cells to Text does not work, nor
>> > does
>> > General, as the ' was typed into the cells. I tried to use Find and
>> > Replace,
>> > but that didn't work for me.
>> > Is there a way to maybe use a formula to get only the apostrophe out of
>> > the
>> > 825 cells?
>> > Any help will be greatly appreciated.
>>

I'll be da***d - that was it!!!
Thank you SO, SO much, both of you, and I apologize for my stupidity.
I was searching for the option to add radio buttons, although I had no idea
what that would be good for ... hahahaha.
Thank you again, that was MOST helpful.

"Peo Sjoblom" wrote:

> He meant that you should select add in the paste special options, those
> round circles that you can select are called radio buttons (or options
> buttons)
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
>
> "Hilde" <(E-Mail Removed)> wrote in message
> newsD730D26-069E-47A7-85CB-(E-Mail Removed)...
> > Thank you, JE. Unfortunatley, I don't have the option to Add radio
> > buttons. I
> > am working with Excel 2002 SP3. Sorry, I should have clarified that in my
> > question.
> >
> > "JE McGimpsey" wrote:
> >
> >> One way:
> >>
> >> Copy an empty cell. Select your 825 cells. Choose Edit/Paste Special,
> >> selecting the Values and Add radio buttons. Click Next.
> >>
> >> In article <B46E2ABE-74BA-4980-A847-(E-Mail Removed)>,
> >> Hilde <(E-Mail Removed)> wrote:
> >>
> >> > I have an Excel spreadsheet with a column of 825 numbers. These numbers
> >> > were
> >> > put in with the preceding apostrophe so Excel recognizes the numbers as
> >> > text.
> >> > The spreadsheet was probably created with an older version of Excel.
> >> > I need to get the apostrophes (') out of the cells as I have to import
> >> > the
> >> > whole spreadsheet into a certain program, which cannot read the symbol,
> >> > and
> >> > thus the import fails. Formatting the cells to Text does not work, nor
> >> > does
> >> > General, as the ' was typed into the cells. I tried to use Find and
> >> > Replace,
> >> > but that didn't work for me.
> >> > Is there a way to maybe use a formula to get only the apostrophe out of
> >> > the
> >> > 825 cells?
> >> > Any help will be greatly appreciated.
> >>
>
>
>