# Lotus 123 Had A Function: Show Plus Symbols(+) Or Negative Symbols (-) For The Value Of The Data

Aug 1, 2009
Lotus 123 had a function where you could graphically, in a cell, show plus symbols(+) or negative symbols (-) for the value of the data. For example if you had a column of numbers that you calculated from the previous year that indicate the change, Lotus, in the next cell would allow you to graphically display the symbols that indicate the strength of the change. So if your result was a positive ten then ten plus symbols would be shown. If it was -20 then 20 negative symbols would be shown. Now the numbers I am looking at could be 600,00 and I believe there was a way to to proportion the symbols for example for every 100,000 put in one symbol so the result would be 6 (+) signs.

View 5 Replies
ADVERTISEMENT
Oct 8, 2008

I have a linked document, only 2 sheets. On the first sheet there is a column for + or - signs, I need a formula for the second sheet to show the + as a 6 and the - as a 5 instead of just the symbols carrying over.

View 3 Replies
View Related
Sep 30, 2011

In trying to create a formula that remove EVERY symbol from a cell (C6) and replacing it with a space.... the "SUBSTITUTE" function is telling me I have too many nested Substitutes.

This is the formula:

Code:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE

(C6,"/"," "),"%"," "),"!"," "),","," "),"*"," "),"-"," "),"("," "),")"," ")

It works thus far, but I would still like to add more symbols into the nest. Is there a way/formula to do this that replaces ANY symbol with a space?

View 9 Replies
View Related
Jan 13, 2009

I have a spreadsheet that creates a named file using data entered into a field. For a hypothetical example, people can put their favorite car in A2 and, when the macro is run, it will SAVE AS the spreadsheet and name it with the value of A2. Problem is, some folks don't follow instructions and do things like HONDA / INSIGHT, or else something using symbols that are not valid for file names.

I know there are lots of ways to use Data Validation to prevent certain entries, but is there any way to prevent certain symbols? If not, can anyone help me with an Event Handler that would evaluate the data for certain symbols once the data is entered?

View 9 Replies
View Related
Apr 23, 2014

I use an excel spreadsheet alot for billing in the construction industry. There are premade formulas in this spreadsheet. When no input value is present, the total column(s) either show a "$0.00" or show "#DIV/0!". How do I hide these results for the rows that do not yet have any input? I have seen it done on other speadsheets

View 3 Replies
View Related
Mar 14, 2007

I need to display the currency symbols for all European & Asia Pacific countries. The only ones available that I could find in excel help are , , . Does anyone know if there are more available? This seems limiting.

View 9 Replies
View Related
Jun 17, 2008

I have lists of phone numbers with parenthases and hyphens. like (555) 333-4444

I would like to remove all symbols and leave just the numbers.

I would alsolike to add the number 1 in the first position.

so (555)333-4444 would end up 15553334444

View 9 Replies
View Related
Jun 4, 2009

is there a way to use the "1/4" symbol as 0.25 in a calculation?

View 9 Replies
View Related
May 17, 2014

I've got a workbook with multiple formulas e.g.:

t=S/D

TCh=Ch*(S^2/2D)*(D/Q)

TC=Co*(D/Q)+Ch*((i-D)/2i)*Q

which are built by implementing the symbols:

t, S, D, TCh, Ch, Q, TC, Co, i

I'd like to substitute the symbols in following sequence:

t = a

S = b

D = c

TCh = d

Ch = e

Q = f

TC = g

Co = h

i = x

Questions:

1) Which formula could substitute the symbols automaticly?

2) If there are up to 100 formulas in the workbook in the range of A1:E100,-

would it be possible to to set the substitution for the mentioned range?

See the attachment.

View 5 Replies
View Related
May 8, 2009

I have a column with e mail addresses that all have > < this symbols in the beginning and at the end, how can I remove them from the column?

example

<Ana.Gomez@taca.com>

View 6 Replies
View Related
Sep 18, 2009

Im looking for a formula to count different symbols in a row. I am using =COUNTIF(A1:A1600,CHAR(251)) to count 1 symbol and =COUNTIF(A1:A1600,CHAR(252)) to count another. what i need is a formula to count all symbols no matter what they are. As in this case they will only be the 251 + 252 a formula just for that would be great.

View 4 Replies
View Related
Oct 27, 2009

I have a worksheet with what appears to be symbols or text boxes; squares, some with a check mark in them, some without. cannot select any of them to edit or delete them, I can type in the cell behind the symbol, the symbol hides the text. I can copy and paste them, but not delete them. how to identify them to edit and/or delete them. Password protection and all cells are unlocked as well. I have stumped as well as other forums.

View 4 Replies
View Related
Feb 4, 2010

Can i find a list anywhere of the new Excel 2007 ALT numbers to give the symbols eg Alt0186 = the degrees symbol in 03 but doesnt work in 07?

View 10 Replies
View Related
Jan 8, 2012

I need to delete cells that contain certain characters (symbols) and space. Say I have some columns/rows like -

Column 1 Column 2 Column 3 Column 4 Column 5 Text Box Text Box Power Power Place Nice Nice.Plus Jump Jump Over High (Jump) Car Black Car Green.Car Car's Color Cars Blue Color Green Red (Color) Black White

And now I need to have cell without those contain symbols or space or character like -

Column 1 Column 2 Column 3 Column 4 Column 5 Text Box

Power

Nice

Jump

[Code]....

View 7 Replies
View Related
Jan 28, 2012

VBA code for inserting "X" for wrong and Tick mark symbol for completed items.

View 5 Replies
View Related
May 8, 2013

I am importing content control information in a word file into excel by using a macro in excel. The information is coming across nicely but when the information about a checkbox comes across, in excel, that's what you see, a checkbox (☐ or ☒). Is there any way (formula or vba) to replace all the checkboxes with a yes or a no?

I wrote a formula that works:

Code:

=IF(G8="☒","YeS","nO")

But this will add this information to a new column and I would like to replace the information in the existing column (the form has about 200 checkboxes) and I don't want to add a bunch of new columns.

I also toyed with VBA:

Code:

Range("G1:G100").Replace "&", "No"

But when I try to paste the ☐ in the vba code, I get a "?" so I am assuming it doesn't recognize the ☐ as a valid character.

View 6 Replies
View Related
Jan 9, 2014

This is my qns

cell A1 having <txt>NEWM</txt>

cell A2 having <txt>RSQ</txt>

I need to display NEWM in B1 and RSQ in B2....

View 2 Replies
View Related
Oct 21, 2008

way to convert all symbols ( ) to their equvilant letters (u a) I know that I can do this manualuy with Find replace but I was hoping there was some magic that I am missing.

Please note that the exapples are only 2 of the symbols I need to convert the sheet could contain all of the varieties of symbol.

View 9 Replies
View Related
Jun 9, 2009

I have created a survey on excel. When completing the survey, the customer will have to place an "X" in the appropriate column (very satisfied, satisfied, dissatisfied, etc.) Is there a formula in excel that will allow me to add the number of responses ("X's") for Very Satisfied, Satisfied, etc.???

View 9 Replies
View Related
Jun 17, 2006

Could anyone guide me how to express symbols & signs in VBA , LIKE ....

View 6 Replies
View Related
Aug 20, 2006

some times we use numeric symbols with formulas such as subtotal(109,a1:a100)

109 here meaning the visible cells only. well, Iwant to know if other numeric symbols also used in formulas !

View 3 Replies
View Related
Jan 5, 2008

I am trying to write some code that will repair errors in a standard workbook. One of the errors is a blank cell that needs to be changed to "325F T 350F". How do I insert these symbols/operators into the VBA code?

View 6 Replies
View Related
Feb 18, 2009

I use dot symbols in one column of my spreadsheet to call attention to a particular row. I am currently using ASCII(decimal) Char 149 and I count the column of dots with the following formula: =COUNTIF(A1:A20,CHAR(149))

This works fine, however, ASCII(decimal) Char 149 is a very small dot which is hard to see. I have found a much larger dot which is identified as BlackCircle Unicode(hex) 25CF. From an appearance standpoint the BlackCircle is much larger and much easier to see, however, I have been unable to construct a formula which will count the dots. How do I identify BlackCircle Unicode(hex) 25CF in order to count the character using the formula listed below: =COUNTIF(A165:A184,CHAR(25CF))

View 2 Replies
View Related
May 8, 2009

Counting with text and symbols mixed in. This is what I'm wanting to do:

For example:

View 5 Replies
View Related
May 18, 2009

I've got a column with numbers. some of the numbers have the following signs/symbols proceeding the value in the same cell: ',ft,#,ea,each. I want to have these removed by a formula so that the numerical values are alone.

View 3 Replies
View Related
Jun 9, 2009

I have two worksheets: "1" and "2" Now i want to filter all symbols used in Column A sheet "1" and list them in Column A of sheet "2". The results should contain no duplicates. For example:..........

View 5 Replies
View Related
Dec 9, 2011

On my spreadsheet, I have used an IF statement formula to get rid of any < values that I have in my tables e.g.

View 9 Replies
View Related
Oct 25, 2012

where i can find symbols to place in Excel..i am looking for a warning sign,home and a large hand with the palm facing down with a pointing finger.

View 1 Replies
View Related
Feb 2, 2009

I need to convert measurements with (',") symbols attahced to them. See attached cells. Excel does not like the symbols and I cannot figure out a way to have it convert the values into tenths of a foot. For example, from the list below I need to convert 7'2" to 7.17. I have years of data. How do I do this?

7'2"7'1"7'0"6'11"6'10"6'9"

View 9 Replies
View Related
May 26, 2009

In a MSquery on a ODBC source I am have a field in which there are several values in one (alfanumeric) field seperated by an alfa key.

Example:

A1 = &&&1000,80&&&500,35&&&11810 ABC&&&

The values between the &&& have to be copied into other cells so that I can use them for calculations

Example:

B1 = 1000,80

C1 = 500,35

D1 = 11810 ABC

View 9 Replies
View Related