ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   function removal (https://www.excelbanter.com/excel-discussion-misc-queries/218362-function-removal.html)

Joytrink

function removal
 
I need to remove the function from one of my columns in a document. The
other columns have a common function, but I need to use symbols in the first
column that are not allowed in a function is in place. Can this be done?

Niek Otten

function removal
 
Can you describe in somewhat more detail:
a) what you have
b) what you try to achieve

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Joytrink" wrote in message
...
I need to remove the function from one of my columns in a document. The
other columns have a common function, but I need to use symbols in the
first
column that are not allowed in a function is in place. Can this be done?



Joytrink

function removal
 


"Niek Otten" wrote:

Can you describe in somewhat more detail:
a) what you have
b) what you try to achieve

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Joytrink" wrote in message
...
I need to remove the function from one of my columns in a document. The
other columns have a common function, but I need to use symbols in the
first
column that are not allowed in a function is in place. Can this be done?


Hi Niek,

I have done this before but can't for the life of me remember how I did it.
Basically I need to enter info in the first column of my report that uses
characters normally used in the formula function. I am getting an error
that won't allow me to type what I need to put into column A.
Joyce

Joytrink

function removal
 


"Joytrink" wrote:



"Niek Otten" wrote:

Can you describe in somewhat more detail:
a) what you have
b) what you try to achieve

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Joytrink" wrote in message
...
I need to remove the function from one of my columns in a document. The
other columns have a common function, but I need to use symbols in the
first
column that are not allowed in a function is in place. Can this be done?


Hi Niek,

I have done this before but can't for the life of me remember how I did it.
Basically I need to enter info in the first column of my report that uses
characters normally used in the formula function. I am getting an error
that won't allow me to type what I need to put into column A.
Joyce

Hi Niek,
I figured it out. all I have to do is enter a single (') before the
character that I want to imput. thanks anyway. Have a nice weekend


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com