Deleting the "'" character in the text formula
 

Hi,

I have a load of formulae currently displayed as text. This is not a case
of converting using the 'Number' from the Category selection.

At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
to the ' then deleting it and hitting the Ente key. I dont fancy doing this
for a couple of hundred cells. Any solutions to this would be appreciated.

Thanks

John

Deleting the "'" character in the text formula
 

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Deleting the "'" character in the text formula
 

Hi John,

Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.

Hope this helps.

Pete

Niek Otten wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Deleting the "'" character in the text formula
 

Enter and run this small macro:

Sub tic_killer()
For Each r In ActiveSheet.UsedRange
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub

(find/replace may not work)
--
Gary's Student


"John" wrote:

Hi,

I have a load of formulae currently displayed as text. This is not a case
of converting using the 'Number' from the Category selection.

At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
to the ' then deleting it and hitting the Ente key. I dont fancy doing this
for a couple of hundred cells. Any solutions to this would be appreciated.

Thanks

John

Deleting the "'" character in the text formula
 

Hi Niek,

Nope. Edit Find and Replace wont work! Here's the formulae in the cell
=counta(H:\Work\[Cases_Older_Than_One_Year.xls]110107!$A:$A)-1
Before the = is ' If i hit F2 Home then Delete then Enter.

Any thoughts please?

Thanks

John


"Niek Otten" wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Deleting the "'" character in the text formula
 

Hi Pete,

Well you learn something new everyday. Must remember that one.

Thanks

John


"Pete_UK" wrote:

Hi John,

Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.

Hope this helps.

Pete

Niek Otten wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John

Deleting the "'" character in the text formula
 

Hi John,

thanks for feeding back.

I saw the tip on this forum several months ago - I think it was from
Rag Dyer.

Pete

John wrote:

Hi Pete,

Well you learn something new everyday. Must remember that one.

Thanks

John


"Pete_UK" wrote:

Hi John,

Try this: highlight the column with the formulae you would like to
change, click on Data | Text-to-columns and then click Finish on the
first panel.

Hope this helps.

Pete

Niek Otten wrote:

Hi John,

Edit|Find and replace?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John" wrote in message ...
| Hi,
|
| I have a load of formulae currently displayed as text. This is not a case
| of converting using the 'Number' from the Category selection.
|
| At the moment i can manually resolve this one using EDIT HOME or BACKSPACING
| to the ' then deleting it and hitting the Ente key. I dont fancy doing this
| for a couple of hundred cells. Any solutions to this would be appreciated.
|
| Thanks
|
| John